how do i rotate a 3 shift 200man schedule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

like 80 people on two shifts and 40 on the third. i want to move small shift to day and slide half of day into swing and half of swing into graveyard. any suggestions? thanks in advance.
 
First rotation: pick the first 40 people (by alphabetic order) from the
larger groups to rotate to the next shift.
Each subsequent rotation: move the group of 40 that did not move the
last time.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I make Excel recognize a time period 3
Ensuring 3 cells do NOT match 12
Find Same Cell... Different Sheet??? 1
Midpoint of times in shifts 6
shift bid scheduling 1
Adding up total hours worked on employee schedule using various criteria 0
Information changes daily 4
Conditional Field 8

Back
Top