I have two tables:
one having
start time and end time, with each possible value throughout the day. end time is just 15 minutes after start time.
the second table:
gives ranges of time that are unvailable. these ranges of time can be any length.
HOW how how how how can I subtract the ranges of unavailable time out from the list of possible times?
I can get it to work when there is a single block of unavailability, but not when there are multiple.
Please help! this is urgent.
one having
start time and end time, with each possible value throughout the day. end time is just 15 minutes after start time.
the second table:
gives ranges of time that are unvailable. these ranges of time can be any length.
HOW how how how how can I subtract the ranges of unavailable time out from the list of possible times?
I can get it to work when there is a single block of unavailability, but not when there are multiple.
Please help! this is urgent.