Need Formula that numerous visit cannot be made at the same time and date if on a visit already

[Leicester City Fox]

Hi All
I have the date of visit and Visitor ID . I need a formula thathighlight if a visitor made a visit within the same time in other words they alsoclaimed to make a visit between Arrival time and Departure time on same date.
In other word I have visitors claiming they were on onevisit but also stating at the same time they were on another visit which is impossible.
Example sample data:
Date (A) Visitor ID (B) Arrival Time (C) Departure time (D)

A)20/08/2019 123 09:14 10:00

B)20/08/2019 012 13:24 13:55
C)20/08/2019 123 09:20 09:30 (Cannot be true row Ashows already on time visit and date)

D)20/08/2019 012 09:10 09:30


I just trying to highlight visitors make false claims that thereare on different visits on the same date when the times show they can’t bethere because there already on a visit. I would be grateful for any ideas but Ihave a big list of dates and different visitor ids to check.
Thank you for any help in this matter
The Leicester Fox

 

[jasonb75]

Try something like

=COUNTIFS(A:A,A2,B:B,B2,C:C,">="&C2,C:C,"<="&D2)

If I have my logic correct then this should give a count of 1 for all valid visits and a count of 2 or more for false claims while still allowing consecutive visits on the same day (i.e. if they leave, then return an hour later each visit will still show as 1).

 

[Leicester City Fox]

Hi Jasonb75,

Thank you very much you’re a star it works &#55357;&#56842;


Many Thanks

Leicester Fox