Sum total hours worked in excel

[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)

 

[Pete_UK]

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