making a shiftcalender

Originally Posted by kmh31872

Hello,

I'm searching for a way to make a shiftcalender in excel.
The whole year i'm having troubles with my planning to do it in a system of my boss and i want to change this for next year.
We need to have always a minimum of 2 people on duty and when someone calls in sick i want to see in for instance a collor that the planning is corrupt and that i have to call someone else to do the shift.

I've looked several up on the net and there are many types of shiftcalenders but not the one i have in mind.

What it needs to do is;

- There are 5 teams with 3 people in it, so 15 names,
- There are 3 shifts from 06:30 to 15:00(dayshift), 14:30 to 23:00(eveningshift) and 22:30 to 7:00(nightshift
It's a 2-2-2 type of shift, that means 2 day-, 2 evening- and 2 nightshift and after the cyclus 4 days free which the first day a day to sleep.

1) How many people on duty per shift?
2) Why does a team have 3 people on it and does that mean that one person sits out if there are only 2 people on shift?