Formula to get times from range of cells

Hi, I have attached an example file of the project I am working on. This example focuses only on the first day as data will copy down.

Working backwards, Sheet 3 shows a legend for inputs in Sheet 1, and also number of hours used/remaining for the week. This is fully automated from Sheet 1 and so far works fine.

Sheet 2 is the printable finished weekly rota auto-populated from Sheet 1, nothing gets input on this Sheet.

Sheet 1 is where all the work is done and this is where my problem lies. Its the data on this sheet columns V,W + X that auto-populate sheet 2.

The current formula I have in column X seems to work fine, displaying the unpaid lunch breaks.

I am looking for formulas to go in column V & W that will show results as the example looks.

Currently row 2 is just text, it may be that I need to change this to time but I'm not sure what to do.

There is also conditional formatting to automatically colour fill the cells.

Any help appreciated.

Thanks for quick reply.

This solution is much simpler but doesn't work with the times that are quarter to or quarter past the hour?

Seems to work great, you're a legend.

On going project so I will look out for you in my next Thread