Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
set up rota shift workers
how can i set a work rota that is in the working time directive and also
rotates names each week |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
set up rota shift workers
That would depend on how many teams there we-
4 teams is 24*7/4 = 42 hrs/wk 5 teams is 24*7/5 = 33.6 hrs/wk 6 teasm is 24*7/6 = 28 hrs week and the shift length 8hrs or 12 hrs or some hybrid system. The EWTD directive limits the working week (with exceptions) to 48hrs averaged over a rolling 17 week period and guarantees 11hrs unbroken rest every day. So as you may gather from the information you have provided it's diffiocult to provide too much guidance. have a look he http://www.dh.gov.uk/en/Policyandgui...tive/index.htm and here http://web.ukonline.co.uk/bjlogie/schedules.htm Mike "Toady" wrote: how can i set a work rota that is in the working time directive and also rotates names each week |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rota Projection | Excel Discussion (Misc queries) | |||
Rota | Excel Discussion (Misc queries) | |||
Staff rota, how can I make a letter represent a shift? | Excel Discussion (Misc queries) | |||
i want to calculate the houers of workers 21:00 - 05:00 =8 | Excel Worksheet Functions | |||
h24 workers with excel | New Users to Excel |