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-hour shifts with two work groups 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
that work during that time.


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