Sum total hours worked in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to add the total hours worked in excel that I book for the month for
example:

A B C
Start Time End Time Total
08:00 16:00 08:00
08:00 14:30 06:30
08:00 15:00 09:30
Total 00:45
It stop at 23:59 and I want it to go on like a total sum, wat formula must I
use to do my total sum calc for my time? please help

Frankie
e-mail: (e-mail address removed)
 
You should format the cells in column C as [h]:mm - that way they will
not wrap round above 24 hours, but will show as 27:45 for example.

Hope this helps.

Pete
 
Back
Top