| 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 |
| 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 | |||
Threaded Mode
