hi

would it be possible to create a marco that creates a 24 hour shift pattern for 7 members of staff just by putting in how many hours they have to work a week

the shifts are

7-2
8-3
11-7
2-9
3-sleep (goes from 3-11, then sleep and work 7-8:30)
and a waking night which starts at 8:30 and finishes at 8:30 the next day

on the early shift there needs to be two staff members one 7-2 and one 8-3
1 on the 11-7 shift
1on the 2-9
1 on the 3-sleep would generally do the 7-2 the next day
and 1 on the waking night can do 3 wakings in a row but cant work the rest of the week

everyone needs two days off a week as well

if anyone can help that would be awesome