making a shiftcalender

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.

I would like to proceed with the last date of the excisting calender and that the sheet automatically fills in the rest.

I hope someone can help me.

Greetz
Micha
kmh

Posts: 1
Joined: Sun Dec 29, 2013 11:27 am