I would like to know if any of you would have an idea of how to accomplish the following?:
I have a table of times:
I also have a schedule table that is using times[Time] list to select the [Time From] and [Time To] for a booking.
However, I would like to be able to only show the times that have not been selected previously and also any times in between all previous [Time From] and [Time To] within the schedule for the same date.
If I have a booking from 07:00 to 07:30 then the [Time From] will not allow me to select either 07:00 or 07:15 but as the booking has ended at 07:30 I can select 07:30 for the next booking slot.