Checking for date and time overlaps

D

D3JAdwin

Hello,

I am having a problem with a list of dates and times that need to b
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 no
figured out how to combine the 'on the same date' check with the 'a
the same time' check.

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top