Finding Overlapping Date Entries with matching IDs

Hello all,

I'm trying to find a way to find, and later delete, date entries which are overlapping but also belong to the same person or unique ID. In the Excel sheet I've attached I have Sally checked-in 3 times, an exact duplicate from 9:30-18:10 and another from 10:30 to 16:30. Since she can only have one check in at a time I need to be able to find the ones that overlap with her name only so I can remove them later. I've also included an entry from 21:00-23:30, which is acceptable because she has only one check in for that period.

I need a solution that would be applicable to the other entries as well. Such as Joe which has overlapping Check In times. Note-The dataset I'm working with is also quite large.

So far I've been able to use =IF with >= and MEDIAN functions to determine whether or not the data was overlapping but I haven't been able to combine that with another =IF or a Vlookup to make sure the Names/IDs are identical.

Thanks in advance for any help you can provide.

In D2 copied down, this works in your example

=IF(SUMPRODUCT(--($A$2:$A2=A2),($B$2:$B2<=B2)*($C$2:$C2>=C2))>1,"Delete","")
Then filter the data on column D and delete those rows.