Thank you soooooooooo much! Seriously, what a great help!

I don't suppose you know how to change the colour/font of the cells when they are in between times. This is so people can clearly see when they arein, and where the staffing is spread out throughout the day, and will go towards an hourly total of staffing levels.

Ideally, I need to add these cells up at the bottom, so I can say between 16:00 - 17:00 there are 14 people working, at 21:00-22:00 10 people are working., so ideally, they would need a value of 1. I could just change the font so it blends white, so they can't see 1 when it's printed. My main concern is getting them to change colour and automatically adding the value of 1 to each cell. I would also need to change some cells manually after for breaks eg, 0.75, or .50 depending on their break length for accurate hourly totals.

So for example, I type in one persons hours 10:00-16:00, their break automatically appears (already achieved - thank you ), the boxes representing the hours are turned from default grey to white, and their is some numerical value for each hour they are in which can be added to the total at the bottom. I have done a screen cap which I have attached so you get an idea.

Once again, thank you! Hope you can help, but I understand if you've had enough! ha.

Much appreciated!!!

Screen Shot 2012-10-01 at 22.58.03.png