Assistance in setting up some roster alerts.

Test1.xls

Greetings everyone,

I've had a look through to try and work out what formulas to use and I'm drawing a blank. I'm trying to set up some automatic notifications in my excel roster to alert me of:

• That there are no more than 6 Shifts in a row
  That there are no more than 10 shifts per fortnight
  That there is a minimum of 10 hours between each shift.

I'm working on a yearly template to make things easier for the person making the rosters, but we normally will only produce a month or two at a time. To denote each fortnight we have the large black line in the left. Please note that there are different shifts spread out across the entire page. I have made a list of initials on worksheet 2, which we set up for each employee. There are instances where we have multiple staff members working the same shift, so the search needs to somehow (hopefully) be able to search for both.

As a final bonus, if it is possable to count on a seperate worksheet the number of 0000-0800 shifts for each staff member it would be wonderful. If you have any questions, or I have not explained everything properly please let me know. I'm really rather stumped! I'm hoping that you wonderful people are able to help me out, or if not at least point me in the direction that I should be looking in.

Thanks.

Jabbitar

Just a little bump. Does anyone have any suggestions as to where I should start looking, what sort of formulas to use?