breynolds0431
Active Member
- Joined
- Feb 15, 2013
- Messages
- 303
- Office Version
- 365
- 2016
- Platform
- Windows
Not sure why the below is so wide. But, I'm needing to identify overlapping times from the below example. I think the Overlap Minutes would be more difficult, so if anyone has an accurate formula to identify a way to flag the overlap rows, that would work too. I have a formula to check each row and if the time on that row overlaps with the time on the row above it, but it would be more accurate if the overlap could be evaluated across the entire table.
RECORD NO | Start Time | End Time | Overlap Flag | Overlap Minutes |
148 | 8:48 AM | 9:03 AM | ||
149 | 10:37 AM | 10:52 AM | ||
150 | 10:43 AM | 10:58 AM | ||
151 | 11:11 AM | 11:26 AM | ||
152 | 11:21 AM | 11:36 AM | ||
153 | 12:28 PM | 12:58 PM | ||
154 | 12:42 PM | 12:57 PM | ||
155 | 1:09 PM | 1:24 PM | ||
156 | 1:27 PM | 1:57 PM | ||
157 | 1:46 PM | 2:01 PM | ||
158 | 4:01 PM | 4:16 PM | ||
159 | 8:17 PM | 8:32 PM |
| |