Summing times

[Guest]

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]

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

 

[Dave Peterson]

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