Hi team,
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:
[Time]
07:00
07:15
07:30
07:45โฆ
I also have a schedule table that is using times[Time] list to select the [Time From] and [Time To] for a booking.
[ID]
[Date]
[Time From]
[Time To]
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.
For example:
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.
Many thanks
Chris.
User | Count |
---|---|
35 | |
34 | |
26 | |
23 | |
18 |