Hello,
I'm trying to determine if there are any overlapping time intervals within one day.
The data looks like this:
12/8/2014 11:30:00 AM 12:00:00 PM
12/8/2014 11:45:00 AM 12:30:00 PM <-- Overlaps the time interval in the record above it.
12/8/2014 6:00:00 PM 8:00:00 PM
I would like the column to the right of these two columns to inform me that "YES" somewhere in these two columns, within the same day, an overlapping of time exists.
Any help would be appreciated!
Thanks,
Channing
"I would like the column to the right of these two columns"
You don't say where the 2nd column begins.
What's in the first and second columns
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
I can see how that would make things confusing. The columns are as follows --
A1
12/8/2014
B1
11:30:00 AM
C1
12:00:00 PM
Thanks!
Channing
Last edited by cworkman123; 01-08-2015 at 09:37 AM.
Still struggling with solving the problem.
If the times are sorted by start time in each day then presumably there is only an overlap if the end time from one row is later than the start time for the next row.....and both are the same date, so in formula terms try this formula in D2 copied down
=IF(AND(A1=A2,C1>B2),"Yes","")
Audere est facere
Perfect, Thank you so much!
Channing Workman
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks