On May 1, 6:48*am, excel moron <excel
wrote:
I am trying to create a 24-hour staffing schedule but I cannot figure out how
to automate the process.

There are 7 overlapping 12-hourshiftswith twoworkgroups A & B. *A works
3 12 hour days with 4 off then works 4 12-hour days with 3 days off. *B works
when A is off.

I am cannot figure out a formula to get excel to do the following:

Place the number of people working from say 3pm-3am when there are 4 shift
thatworkduring that time.

I have almost no experience with excel and it may be too much to get here
but thought I'd ask.

Your A&B pattern will always mean respective teams will have the same
recurring days off i.e. one of the teams will never get a weekend off
ever, while the other always gets long weekends off. Do they really
want to do that? To rota days off across days of the week your day-on-
day-off ratio must < 7.

Regards
Tim Mills
Intellicate
http://www.intellicate.com