bevo993071
New Member
- Joined
- Jul 28, 2015
- Messages
- 3
Can anyone help me with a formula to determine if two date/time stamps representing a range of time overlaps with another? I am been playing around with SUMPRODUCT however am unable to figure it out... I am dealing with multiple aircraft out of one base. See example below:
<tbody>
</tbody>
Thank you all
Departed | Arrived | Overlap |
5/1/15 04:30 | 5/1/15 08:30 | YES |
5/1/15 06:45 | 5/1/15 06:45 | YES |
5/2/15 08:15 | 5/2/15 09:15 | NO |
5/2/15 13:15 | 5/2/15 16:15 | NO |
<tbody>
</tbody>
Thank you all