Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Driver Hours Of Service
I cannot figure out a formula for this.
Drivers can work no more then 60 hours in seven days They cannot work over 14 hours per day There is a big day 16 hour exception rule that they can use once a week. If they have 34 hours off duty their time resets to 60 hours. I need to track their hours on a weekly basis and know how much available time they have left for each day. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date and Time Response- before/during/after Business hours | Excel Discussion (Misc queries) | |||
Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |