Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help need formula for working out date overlaps | Excel Worksheet Functions | |||
Calculating Time with Date/Time checking in formula | Excel Worksheet Functions | |||
Calculation Total Time With Dates/Times That Overlaps | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Identifying Date Overlaps | Excel Discussion (Misc queries) |