Simple Class schedule for 5 students into one sheet?

Hello,

This is my first post and I need some help with a seemingly simple question.

Essentially I'm in charge of managing schedule for 5 students, I would like to get them to meet during their free time (free for all 5 of them)

1. Schedule has to run from 8 am to 9 pm.
2. I have all 5 individual schedules.

I want to combine all 5 into one so everyone can see their free/occupied times, it would be extra helpful if I can modify individual schedules (One student's work schedule changes bi weekly).


It has to be able to show who is occupied at which time and free time for all of them. (color coding each of them would be amazing also, granted I can show multiple clashes with gradient or something similar)

I understand it involved creating individual spreadsheets and a master sheet but I have no idea how to go on about it.

Thank you.

Hi,
Welcome to the forum

In the attached sheet is a similar format desired by you. Rows 2 to 6 have drop downs wherein you can select Occupied, Free or Break. The conditional formatting is in row 1.

I hope this works for you and for mac !