Shift Schedule

[Aeddy]

Hello,

I would like to create a spreadsheet that allows auto-scheduling of employees. I work in an emergency room so we need 24 hour coverage. In August we will have 9 people to schedule. Ideally, I'd like to have two options available (10 hour shifts for one schedule, and 12 hours for another to decide which one works best.) I've broken things out to two tabs. At most, in a row would be 5 shifts on, 5 off. I'd like to be able to mark when they are not available as well. Please let me know if this is do-able!

Thanks for your help,
Amanda