Rota in Excel - Formula for creating daily overview based on shifts times

Hi Pokerman.
Just a small encouragement, expand your horizon, experiment with VBA in your own time.
My personal reasons for using it in preference to on sheet formula are based upon my own experiences.
When working in a multi-person environment there is always the need to stop meddling little fingers modifying your sheets.
To this end I find the VBA approach far more flexible with regard to security.
Look at the attached code is it REALLY anymore difficult to figure out than complex sheet formula ???
As a 76 year old with the attention span of a goldfish I know which I find easier.

Ali, To use B1:M1 as a 24 hour format I found I had to format it as 'Text' as 'General' it got confused with dates.

Capture.JPG

Rota Example(tora).pdf