Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am designing a spreadsheet in Excel and I need to track employee hours
using the following conditions. I already have a worsheet for each week totaling the hours each day. I need a formula that would account for an employee working more than 60 hours in any consecutive 7 day period. There is also a 70 hr/ 8 day rule and a 120 hour/ 14 day rule. as outlined below. A driver my not drive a truck or bus after having been on duty for, a) 60 hours in 7 consecutive days, without having 8 hours off, or b) 70 hours in 8 consecutive days, or c) 120 hours in 14 consecutive days Please help, Thank you in advance. Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Formula Problem | New Users to Excel | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Baffling formula problem | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Discussion (Misc queries) |