| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to calculate number of hours worked in a day
I am trying to put together a time sheet, where I can put my time in and out,
and then give the total hours at the end of the day. For example, I sum (12 pm -8 am) + (5 pm -1 pm). I have formatted these cells to show time. But my formula spits out a sub zero number. Do I need to divide these by 24? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| Calculate hours worked | New Users to Excel | |||
| Need formula to calculate hours worked | Excel Discussion (Misc queries) | |||
| CALCULATE HOURS WORKED | Excel Discussion (Misc queries) | |||
Threaded Mode
