Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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)

share|improve this question
add comment

2 Answers

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
share|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
add comment

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

share|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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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