i am trying to come up with a eight man rotating schedule without working
long stretches without a day off.

Thx
Brad

Need to post more info than that

e.g

What's the length of day ??
Whats a long stretch in your view ??
How many on per day ??

What cells

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566331

Would this be a 24/7 operation?

8 hour shift?

12 hour shift?

How many hours a week per person?

What is the averaging period? 28 days? 8 weeks?

Have a look at this site to get an idea of how to work with some of the above
and other parameters.

http://www.shift-work.com/shift-schedules/

See some sample schedules when you scroll down to bottom of page.


Gord Dibben MS Excel MVP

On Sat, 29 Jul 2006 14:15:02 -0700, Brad wrote:

i am trying to come up with a eight man rotating schedule without working
long stretches without a day off.

Thx
Brad