Hello,

I am trying to create a automated work schedule but as I don't have a lot of experience with Excel, I'm struggling.


We have 5 days a week open (Tue-Sat), every day apart from friday should 5 persons be working. On Friday 6.

Here the "normal" times:
Tuesday:
2 persons 5.00-13.00
1 person 6.00-12.00
1 person 10.30-18.00
1 person 13.00-18.00

Wednesday:
1 person 5.00-13.00
1 person 5.00-13.30
1 person 6.00-12.00
1 person 13.00-18.00
1 person 13.30-18.00

Thursday:
2 persons 5.00-13.00
1 person 6.00-12.00
2 persons 13.00-18.00

Friday:
2 persons 5.00-13.00
1 person 6.00-12.00
1 person 8.00-12.00
1 person 10.30-18.00
1 person 13.00-18.00

Saturday:
2 persons 5.00-12.00
1 person 6.00-12.00
1 person 6.30-12.00
1 person 7.00-12.00

Each person should try to come as close as possible to their weekly hours.
For some that's 15, others 20, others 8, others 40, others 25.
In total there are 10 workers, but it should be possible to add new workers.

It should also be possible to give excel the information on which date it is not possible to work for each person f.e. because of medical problems.

Thanks a lot for your help.