Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shift scheme
I am trying to setup a schift scheme for employees.
I have 7 employees to rotate in 5 shifts. they have to work 40 hrs per week and have 1 day off. The employee's shifts must elapse 24 hours before his next shift. 3 shifts for cashregisterA with the shift hours S1 23.00-07.00, S2 07.00-15.00 and S3 15.00-23.00. 2 shifts for the cashregisterB with the shift hours S1 07.00-15.00 and S2 15.00-23.00. I have tried to setup something like. jan 123456789......31 feb "" mar "" apr "" may "" jun "" [the names of employees in A,B,C,D,E,F and G, between the jun and jul (7 rows)] jul aug sep oct nov dec Please your help is greatfull. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i remove shift lock (highlighting cells) from excel? | Excel Discussion (Misc queries) | |||
Excel shift table | Excel Discussion (Misc queries) | |||
Formula to determine shift | Excel Worksheet Functions | |||
Need a function that separates over-lapping work shift hours. | Excel Worksheet Functions | |||
Grabbing recods based on date and shift values | Excel Worksheet Functions |