booking time slots

Hi 3
Thank you for looking at this, your amendedment certainly works better than my original effort.

I have attached the wb with what i would ideal like shown on may 14th tab.


I have added times of 5 minute itervals in column a, i would like to add a test type at the side of 8am
and if the allocated time in I was 30 mins this would grey out time slots from 8 to 8.25 highlighting that this is booked and the next available booking could start at 8.30.

If then next booking was for 9.00 with a slot of 55 mins this would do the same etc.

If the test was cancelled or moved it could be deleted without efecting the other enteries

your thoughts would be appreciated

Regards

Peter