Work Schedule - Deducting Lunch Breaks

Hi ManyLemons23

I don't know! Some people are never satisfied!

I could not think of any way of doing it with conditional formatting, so I wrote some vba. Seems to work OK (mind you - it rather defeats the "simplify" objective ! )
I will not insult your intelligence by telling you how to run the code, but to see the code press Ctrl + F8 and select "Step into"

I was just about to send this to you when I discovered a flaw in the original - if the last line rolls over to the next day, it will not display the rollover day properly. There are two possible solutions - pay me lots and lots of money for a complete re-write or add a 5 minute check as a last line (third option - just colour it in!)

Regards
Alastair