Column C has date (e.g. 9/1/2013)
Column D has start time (e.g. 1:00:00 PM)
Column E has end time (e.g. 3:00:00 PM)
My goal is to figure out where there is overlap of times within the same date. For example:
In cells C2 and C3 is the same date, 9/1/2013.
In cell D2 is 1:00:00 PM. In cell E2 is 3:00:00 PM.
In cell D3 is 2:00:00 PM. In cell E3 is 4:00:00 PM.
So there is an overlap of one hour (between 2:00:00 PM and 3:00:00 PM). Is there a formula I can use to indicate/highlight this?
Bookmarks