Trying to find a way to parse out data when record falls between another record. Example on 12/10/18 - Kevin time is doubled on that day....one foreman entered his time from 8-4 and another foreman entered his time from 10-2. Since it is doubled up, I need to highlight that error. Tried various pivot view, with no promising results. In the end, I need to only show records where there is a conflict from the table. Any help would be appreciated.
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Date | Emp | Start Time | End Time | Start Number | End Number | Hours | Foreman |
12/8/2018 | Kevin | 12/8/18 8:00 AM | 12/8/18 3:00 PM | 43442.33 | 43442.63 | 7 | Harry |
12/9/2018 | Kevin | 12/9/18 9:00 AM | 12/9/18 2:00 PM | 43443.38 | 43443.58 | 5 | Harry |
12/10/2018 | Kevin | 12/10/18 8:00 AM | 12/10/18 4:00 PM | 43444.33 | 43444.67 | 8 | Harry |
12/10/2018 | Kevin | 12/10/18 10:00 AM | 12/10/18 2:00 PM | 43444.42 | 43444.58 | 4 | Sam |
12/11/2018 | Kevin | 12/11/18 8:00 AM | 12/11/18 2:00 PM | 43445.33 | 43445.58 | 6 | Harry |
12/11/2018 | Kevin | 12/11/18 2:00 PM | 12/11/18 5:00 PM | 43445.58 | 43445.71 | 3 | Sam |
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>