| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I write the formula to calculate someones time worked
I would like to use excel spreadsheet and calculate a simple payroll time
card. A person start time to work is 10:15 pm (cell A 1) and end time is 2am (cell B 1). What would be the formula for cell c1 to calculate the total number of hours worked which would be 3 3/4 hours total worked. . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting time worked to dollars earned. | New Users to Excel | |||
| Formula to deduct unpaid breaks in time sheet | Excel Discussion (Misc queries) | |||
| Calculate difference in time spanning a day, during office hours o | Excel Discussion (Misc queries) | |||
| I need help with a formula calculating time | Excel Discussion (Misc queries) | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Threaded Mode
