ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   set up rota shift workers (https://www.excelbanter.com/setting-up-configuration-excel/148464-set-up-rota-shift-workers.html)

Toady

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

mlh

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



All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com