Wow, amazing, thankyou so much! One final question regarding this....

Iv copied the cells across for each day of the week. Which part of the formula do I need to change so that when I enter shifts into Tuesday part of the rota they go into Tuesday cell for example?