Time card template

[Guest]

I have a large spreadsheet of time calculations. I have formula to get number
of hours worked per person.
A B C
10:00 AM 2:30 PM 4:30 This formula works
12:00 PM 3:15 PM 3:15 =TEXT(B1:A1,"h:mm")
2:00 PM 7:30 PM 5:30
4:00 PM 5:30 PM 1:30
12:00 AM This formula does not work
=sum(c1:c4) How come? I would like this to work like an old fashioned time
card from the 50's Thanks

 

[Biff]

Hi!

Try this:

Enter this formula in cell C1 and copy down as needed:

Format the cell as h:mm

=IF(COUNT(A1:B1)<2,"",B1-A1+(B1<A1))

Now your Sum formula should work. Format the cell of the Sum formula as
[h]:mm.

Biff