Employees record their overtime based on each task they complete (as they add notes in the time booking).
Sometimes this is when they are on standby and they will get a call out for doing these tasks.
If they do multiple tasks with breaks between them they will get multiple call out payments. However, if there is no gap between the end of one task and the start of the next task they should only get one call out
For example (TIP table):
From To 1 P ID CT P TTyp O Number
10.5000 11.5000 0 3 01 00 ( 1300 P 1.0000
11.5000 13.5000 0 3 01 00 ( 1300 P 2.0000
In this example there should only be one call out paid as there is no gap between the time recordings.
If the 2nd time recording was to start from 11:7500 then 2 call outs should be paid.
My issue is that I can't stop the 2nd call out being generated. How do I (can I?) refer to the previous line in the TIP table to prevent the 2nd call out from being generated?
Any suggestions greatly appreciated.
(Re-posting as original question not linked to my account)