I have used your data set in A2:H22
Sorted the data by location, start time, end time
In a helper cell column I
=AND(H2=H3)*(D2>B3)
This looks for the same site and if the end time is less than the start time for the next entry
Initial test seems to work
edvwvw
Bookmarks