Break Rota with VBA.

Originally Posted by TMS

Wondered about that. It would probably make life easier if the shift start and end values were in separate columns? Is that possible? Not necessarily a show stopper but it will make the formula complex ( I expect ).

So the names are in column A, shifts in column B, and everything else starting in column C??

That would be fine yes! Let's say Names in column A, shift start in B, shift end in C and then everything starting in D.