Just to give a heads up
We can start doing by putting option buttons . I have just attached a screen shot let me know if this is how you think the rota would be
It was just a thought.
The idea is all 6 persons will have only 48 hours(6days*8hrs) in a week so we can compare the values in RANGE."B2" with RANGE ."O2"
Whenever we choose option button1 it considers it as shift 1 12 hours and next shift 2 as hours
Finally it sums up in range("O2") for Staff 1 and so on for other employees. so we can check if we have met our target of
6 employees * 8 hrs day * 6 days = 288hrs
Let me know your inputs we will proceed accordingly
The code can be something like below