Let's say I have the following start and end days/times:
Resulting in a range of time from
Mon 10am through Tues at 11:59pm.
I'd like to know whether this range of time overlaps another range of time on a separate sheet.
Below is an example of 2 date ranges to compare to: one that overlaps and one that doesn't:
I'd like the function in the row associated with
OVERLAP? to return either
FALSE depending on whether there is overlap in the given time range with the range shown for
Is it possible to construct date ranges based on start/end times and then compare that range to other ranges of time to determine if there's overlap?
- Preferably all on the fly (i.e., not saving any outputs to a sheet until the final
Sample Sheet (as comma delimited):
Start Day, Monday, Start Time, 10:00 AM, End Day, Tuesday, End Time, 11:59 PM Day of interest, Monday, Tuesday, DOI start, 8:00 AM, 8:00 AM, DOI end, 9:00 AM, 9:00 AM, OVERLAP?, FALSE, TRUE