Comparing User/Date/Time over 2 tables

[mdex]

We have an effort tracking system for Overtime and Standby. What I would like to be able to do is highlight a users overtime claims that were made when they were on standby, either the Start or End time of OT claims that are during a Standby claim.

All booking are in one table but can easily split them between an OT and Standby table.

User	Team	Time Type	Date	Start Time	End Time
A	1	Standby	01/01/2022	08:00	16:00
B	2	Overtime	01/02/2022	07:30	09:30
A	1	Overtime	01/01/2022	06:00	09:00
A	1	Overtime	01/01/2022	15:00	16:00

3rd and 4th line in this table are examples of what I want to know about. 

I started by splitting the OT and Standby into separate tables and joining using a combination of User/Team/Date but cannot think how to use this in combination with some filtering to hightlight the entries.

Any help appreciated.

[v-henryk-mstf]

Hi @mdex ,

It seems less clear how to get three or four rows of data records based on overtime requests made during on-call, can you give an example and provide a screenshot of the expected results?

Looking forward to your reply.

Best Regards,
Henry

[mdex]

I've decided to simplify this a little to allow me to find my own solution.

I have nested ifs to check is User booked OT and standby on same day, then to see if start time was before 8am or after 6pm.