up vote 3 down vote favorite
2
share [g+] share [fb]

I have a 1 column list of rows that I pasted into excel that look like:

1:15 0:25 0:43

These represent hours and minutes worked each day, I want to sum up the total and see how many hours I have worked. I can't seem to figure out how to do this in Excel, I know I use the formula:

= FIRSTCOLUMN + LASTCOLUMN

but the issue is excel is not handling the format of the column (I think)

link|improve this question
36% accept rate
feedback

2 Answers

up vote 2 down vote

If you just run a "=SUM(firstcell:lastcell)" it should add up hours and minutes properly.
Tried this on Excel and the cells have format: custom, "h:mm".

Update: Couple of references...

  1. Excel Dates and Times FAQ
  2. Date Arithmetic
link|improve this answer
hmm, tried that, it says 0:00 as the result. I did =SUM(A1:A59) – user3183 Sep 6 '09 at 19:29
(and yes I did convert the entire column to custom h:mm) – user3183 Sep 6 '09 at 19:39
Are you on Excel 2007? – pelms Sep 6 '09 at 19:43
1  
make sure the cell with the total is also formatted to hh:mm – pelms Sep 6 '09 at 19:47
This answer is not correct, at least not for my version of office – Casebash Sep 1 '10 at 0:09
feedback
up vote 1 down vote

h:mm or hh:mm show hours or minutes based on a 24 hour clock. [h]:mm or [hh]:mm will not use a 24 hour clock

link|improve this answer
+1 - this is correct [h] or [hh] will show the total number of hours represented by the value in the cell, instead of the number of hours modulo 24. – DMA57361♦ Sep 1 '10 at 14:58
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.