Value filtered by and between multiple values in table

[JHSS_1]

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.

[TABLE="class: grid, width: 721"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Emp[/TD]
[TD]Start Time[/TD]
[TD]End Time[/TD]
[TD]Start Number[/TD]
[TD]End Number[/TD]
[TD]Hours[/TD]
[TD]Foreman[/TD]
[/TR]
[TR]
[TD="align: right"]12/8/2018[/TD]
[TD]Kevin[/TD]
[TD="align: right"]12/8/18 8:00 AM[/TD]
[TD="align: right"]12/8/18 3:00 PM[/TD]
[TD="align: right"]43442.33[/TD]
[TD="align: right"]43442.63[/TD]
[TD="align: right"]7[/TD]
[TD]Harry[/TD]
[/TR]
[TR]
[TD="align: right"]12/9/2018[/TD]
[TD]Kevin[/TD]
[TD="align: right"]12/9/18 9:00 AM[/TD]
[TD="align: right"]12/9/18 2:00 PM[/TD]
[TD="align: right"]43443.38[/TD]
[TD="align: right"]43443.58[/TD]
[TD="align: right"]5[/TD]
[TD]Harry[/TD]
[/TR]
[TR]
[TD="align: right"]12/10/2018[/TD]
[TD]Kevin[/TD]
[TD="align: right"]12/10/18 8:00 AM[/TD]
[TD="align: right"]12/10/18 4:00 PM[/TD]
[TD="align: right"]43444.33[/TD]
[TD="align: right"]43444.67[/TD]
[TD="align: right"]8[/TD]
[TD]Harry[/TD]
[/TR]
[TR]
[TD="align: right"]12/10/2018[/TD]
[TD]Kevin[/TD]
[TD="align: right"]12/10/18 10:00 AM[/TD]
[TD="align: right"]12/10/18 2:00 PM[/TD]
[TD="align: right"]43444.42[/TD]
[TD="align: right"]43444.58[/TD]
[TD="align: right"]4[/TD]
[TD]Sam[/TD]
[/TR]
[TR]
[TD="align: right"]12/11/2018[/TD]
[TD]Kevin[/TD]
[TD="align: right"]12/11/18 8:00 AM[/TD]
[TD="align: right"]12/11/18 2:00 PM[/TD]
[TD="align: right"]43445.33[/TD]
[TD="align: right"]43445.58[/TD]
[TD="align: right"]6[/TD]
[TD]Harry[/TD]
[/TR]
[TR]
[TD="align: right"]12/11/2018[/TD]
[TD]Kevin[/TD]
[TD="align: right"]12/11/18 2:00 PM[/TD]
[TD="align: right"]12/11/18 5:00 PM[/TD]
[TD="align: right"]43445.58[/TD]
[TD="align: right"]43445.71[/TD]
[TD="align: right"]3[/TD]
[TD]Sam[/TD]
[/TR]
</tbody>[/TABLE]

 

[Chrisdontm]

<colgroup><col style="mso-width-source:userset;mso-width-alt:5193; width:107pt" width="142" span="5"> </colgroup><tbody>
[TD="width: 710, colspan: 5"]Try This;[/TD]

[TD="colspan: 5"]Copy this formula;[/TD]

[TD="colspan: 5"]=AND($C3>$C2,$C3<$D2)
[/TD]

[TD="colspan: 5"]Then highlight all the data in columns C & D that you want alerted
[/TD]

[TD="colspan: 5"]Then, on the Home tab click Conditional Formatting in the Styles Group
[/TD]

[TD="colspan: 5"]Go down and click New Rule
[/TD]

[TD="colspan: 5"]Then go down and click Use a formula to determine which cells to format
[/TD]

[TD="colspan: 5"]Then in the middle box, paste the formula[/TD]

[TD="colspan: 5"]Then click the Format button just below and choose a color to fill it with or choose other tabs to format further
[/TD]

[TD="colspan: 5"]Then click OK
[/TD]

[TD="colspan: 5"]Then click OK
[/TD]

[TD="colspan: 5"]Then click Apply
[/TD]

</tbody>