Forum Discussion
Checking if a time range is between a time range for same day but time starts or ends another day
Hello, I am looking for a formula to check if a time range (appointment) is between a certain time range (work shift), but the complexity is both ranges can start on the previous day or end on th...
I'd add the date to the time values.
For example, take 22;30 to 06:00 would become 13-Nov-2023 22:30 to 14-Nov-2023 06:00.
It would then be simple to check that the appointment start time is equal to or after the workshift start time, and the appointment end time is equal to or before the workshift end time.