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 TRUE
or FALSE
depending on whether there is overlap in the given time range with the range shown for SHEET1
.
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
TRUE
/FALSE
.
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