Darren Bartrup
Well-known Member
- Joined
- Mar 13, 2006
- Messages
- 1,297
- Office Version
- 365
- Platform
- Windows
Morning all,
I'm trying to set up a shift rotation pattern for a team at work and I'm getting nowhere.
The basics are that four people in the team will work early shift, eight people will work late shift and everyone else in the team will work core hours.
The shift will change on a weekly basis and preferably work so that people won't go straight from an early to late shift, but rather spend time on the core hours before swapping to early or late.
So my question is - has anyone experience or an idea of how to set up a spreadsheet so that based on a week number, or a date (or anything that works) I will be able to sort out who's on what shift?
I've got about as far as splitting the team into groups of four (with a couple of stragglers as the team won't split exactly) with the idea of moving the groups into different shifts but just can't figure out my sums (why didn't I listen more doing maths at school!).
Any help would be greatly appreciated as always.
I'm trying to set up a shift rotation pattern for a team at work and I'm getting nowhere.
The basics are that four people in the team will work early shift, eight people will work late shift and everyone else in the team will work core hours.
The shift will change on a weekly basis and preferably work so that people won't go straight from an early to late shift, but rather spend time on the core hours before swapping to early or late.
So my question is - has anyone experience or an idea of how to set up a spreadsheet so that based on a week number, or a date (or anything that works) I will be able to sort out who's on what shift?
I've got about as far as splitting the team into groups of four (with a couple of stragglers as the team won't split exactly) with the idea of moving the groups into different shifts but just can't figure out my sums (why didn't I listen more doing maths at school!).
Any help would be greatly appreciated as always.