software

I have a large spreadsheet of time calculations. I have formula to get number
of hours worked per person.
A B C
10:00 AM2:30 PM4:30 This formula works
12:00 PM3:15 PM3:15 =TEXT(B1:A1,quot;h:mmquot;)
2:00 PM7:30 PM5:30
4:00 PM5:30 PM1: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 ThanksHi!

Try this:

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

Format the cell as h:mm

=IF(COUNT(A1:B1)lt;2,quot;quot;,B1-A1 (B1lt;A1))

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

Biff

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