Forum Discussion
Comparing User/Date/Time over 2 tables
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.
2 Replies
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.
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
