Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spread Sheet Employee Hours Issue
Here's the Excel time sheet I've been working on, and here's the problem:
This is an example of an employee who works the overnight shift: When we enter 21:00 as an 'In' time, and 09:00 as the 'Out' time, the total hrs do not calculate properly. If I convert 09:00 to 33:00 (24:00 + 09:00) it works properly, but this is not an acceptable solution since I want to turn this worksheet over to the managers to enter employee's times, and they'll not 'get' it. Just FYI, this is for an assisted living home that has 24 hr staffing. They have been using military time, and it confuses everyone when it comes to totaling the hours, so we want Excel to do the calculating. Do you think you can fix this mess for us?? You'll be my hero! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
macro | Excel Discussion (Misc queries) | |||
Returning Values | Excel Discussion (Misc queries) | |||
Totals sheet - deal with employee names | Excel Worksheet Functions | |||
Referencing a newly created worksheet | Excel Worksheet Functions |