Hello,
I am trying to make a formula that lets me know when an employee needs to have time off (by law there is a maximum amount of hours they can work in an eight week work period).
There are different values for different shifts:
Day: 9 hours
Evening: 9 hours
Night: 7,5 hours
Free: 0 hours
After working an eight week period (48 days that are not "free"), they need to go home.
They do not necessarily need to take an entire week off, but can have long weekends to keep the average legal.
I am trying to make a formula that lets me know when an employee needs to have time off (by law there is a maximum amount of hours they can work in an eight week work period).
There are different values for different shifts:
Day: 9 hours
Evening: 9 hours
Night: 7,5 hours
Free: 0 hours
After working an eight week period (48 days that are not "free"), they need to go home.
They do not necessarily need to take an entire week off, but can have long weekends to keep the average legal.