I'm looking into creating a sheet that will be populated with examination information. Forms will be used for students to submit their requirements but I also want them to book slots.

Is there a way of having a drop down of times but once one student has chosen X time then that is no longer available and only shows available slots on the forms.