Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time card template
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time card template
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 "musicman52151" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template to track credit card expenses and expense reports combi | Excel Discussion (Misc queries) | |||
Time Card | Excel Worksheet Functions | |||
a template for a holiday card list? | New Users to Excel | |||
Need Budget Template for Bills, expenses, credit card balances wh. | New Users to Excel | |||
Appointment Card Template | New Users to Excel |