Skip to Content
Jan 17, 2017 at 08:07 AM

How to refer to the previous time pair on a TIP table - same day only


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)