I'm hoping that someone might be able to help me design the proper code
structure to handle my scenarios.

I gave a range (G11,CX298) it is a work schedule. If a person is
chedule to work a "." is placed in each cell in the range that
designates their shift.

Shifts have different lengths and 8 hour shift is 34 cells. A 10 hour
shift is 42 cells. etc. I also have som other shift lengths that differ
from the ones I mentioned.

I would like to find a way to insert breaks and lunches into each
shift. So for example if the shift is 8 hours (34 cells) I want to
insert a break 2 hours into the shift (8th cell), 4 hours in should be
a Lunch(16th cell) and so on

Here is where it get's tricky. The range is sorted by the shift start
time. So if a group of 8 hour shifts is grouped together and I place in
a break after 2 hours, everyone on the shift would have to go to break
at the same time, which is no good. The breaks need to be staggered to
keep the most people working. So in the next row the break might have
to be placed in cell 7, on the next row maybe cell 6? The object is
to keep the max number of people working at all times.

Obviously there will need to be parameters that define how for a break
can deviate from the 8th cell as well as the other cells

I'm hoping someone can show me the correct way to handle a scenario
like this as opposed to me posting my feeble attemps that will almost
certainally leave something out.

If the parameters could be user defined by the user entering in the
length of break and lunch parameters somewhere, that might be the
easiest way to do it.

Thanks

I'm attaching a small example, the actual workbook is 6meg.

Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=684978
---
Message posted from http://www.ExcelForum.com/