Summing times

Driver · Oct 25, 2005

I'm trying to get Excel to sum times on a worksheet

e.g.
C4=6:00
C5=8:45
C6=9:30

Total hours worked= 24.25. How do I get Excel to understand this?

Any help is appreciated.

Driver

al.rainey · Oct 25, 2005

Format the time as (h):mm:ss and enter the hours even if it is 0.

Dave Peterson · Oct 25, 2005

You could get 24:15 if you used a format of: [hh]:mm

Or use this if you want 24.25
=SUM(c4:c6)*24

Summing times

Driver

al.rainey

Dave Peterson