Checking for date and time overlaps
 

Hello,

I am having a problem with a list of dates and times that need to be checked for overlapping times on the same date

Date. Time in. Time out
1/25/13. 10:00. 11:00
1/26/13. 16:00. 19:30
1/25/13. 10:30. 13:00
1/26/13. 10:00. 13:00

I have been able to get a time overlap check working, but I have not figured out how to combine the 'on the same date' check with the 'at the same time' check.

Ideally this would be a conditional formatting, but a check column would work too if that seems more reasonable.

Please any help, or questions about something I have left out would be greatly appreciated.