#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i remove shift lock (highlighting cells) from excel? catherine47 Excel Discussion (Misc queries) 2 June 19th 06 04:07 PM
Excel shift table voidmain Excel Discussion (Misc queries) 1 November 24th 05 02:42 PM
Formula to determine shift Liz Excel Worksheet Functions 4 August 15th 05 06:52 AM
Need a function that separates over-lapping work shift hours. Katybug1964 Excel Worksheet Functions 0 May 24th 05 03:32 PM
Grabbing recods based on date and shift values Jay Excel Worksheet Functions 1 February 25th 05 02:42 PM


All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"