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) |