JBeaucaire,
You are great. I have pulled out most of my hair on this schedule. LOL. I did not think of doing it this way and besides, I am such a newbie, I probably would have never come up with this masterpiece of formulas. Thank you so much.
If I may impose one more question?
With having 2 stores with the same employees working at both, (we are needing to print out separate schedules for both) how would you have the hours of the employees add up from one store to the other (a running total when we are inputting hours, on both schedules) making sure they do not have more than 40 hours? Some are part-time, so they would only be allowed 30 hours per week (Nick, Lynn, Bill and Troy).
If I am imposing too much I completely understand.
Thanks again!!