LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann
 
Posts: n/a
Default Employees shift schedule

Rossi,

I think that you are not getting any answers because your question is too
vague.

I like to create an employees shift schedule with 4 shifts,i.e
general,first,second & third.
Total no.of employees are 16


Does that mean that there are 4 employees on each shift?

............................Weekly off`s are staggered,i.e emplyee A takes
off on Monday,B takes off on Tue & so on....


With 4 people on each shift and 2 days off per week not all employees can
have their days off??

Note,shift changes from 3rd to 2nd to 1st to General.


Is there a set time required between shifts? ie if one of the shifts is
Nights can another shift start the following day?

Do you have a layout of the shift patern? If so the post it - but NOT as an
attachment on the newsgroup

--
Regards,

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"rossi" wrote in message
...
Hi,

I like to create an employees shift schedule with 4 shifts,i.e
general,first,second & third.
Total no.of employees are 16.Weekly off`s are staggered,i.e emplyee A
takes
off on Monday,B takes off on Tue & so on....
Schedule is made for 1 month.Now,my question is how can I do it?How to
automate it every month?just by changing the month,Schedule should get
updated.
Is it possible?
Note,shift changes from 3rd to 2nd to 1st to General.

Please help if possible.

Bye &


Regards,

ROSSI





 
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
No entire view in edited shift dropdown list Nursing Schedule Exc nanmacarb55 New Users to Excel 8 April 10th 06 10:12 PM
Change formula for Employee Shift Schedule template Pam Soreide Excel Worksheet Functions 1 September 7th 05 03:10 AM
monthly one shift work schedule DasWerkes New Users to Excel 1 August 15th 05 03:34 PM
Where can I find a template for a perpetual shift schedule. korcom2002 Excel Discussion (Misc queries) 0 June 15th 05 07:25 PM
Link a list of employees with hire dates to a monthly schedule lisabrmr Excel Worksheet Functions 0 May 17th 05 08:16 PM


All times are GMT +1. The time now is 02:57 AM.

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

About Us

"It's about Microsoft Excel"