I have a single column list of rows that I pasted into Excel that looks like:


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:


The issue is that the column does not seem to be formatted correctly.


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

  • 1
    +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

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
  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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