how to set delay hours or minutes to zero if calculated overtime covers detected delay?

Hello Ahmed,

It's certainly possible to meet the described requirement with the following configuration. Results of my tests are promising.

Here are the assumptions for this solution:

• Real Overtime must be calculated by subtracting delay from Overtime. A positive difference indicates remaining Overtime. A negative difference indicates Delay time.
• Delay time is already calculated on a daily basis and is used as potential Delay in the configuration. The calculation is not described as part of this configuration.
• Similarly, Overtime is also calculated daily and is used as potential Overtime. The calculation is not described as part of this configuration.

These assumptions are important to consider before implementing the suggested solution. Each organization might have slight variations in how they handle overtime and delay, so adjust the solution as necessary to fit your situation.

The solution looks like this

• First, calculate the difference using the valuation type 'Difference Between Threshold and Input'. If Overtime is more than Delay, your result will be positive. If Delay is more, your result will be negative.
• Next, if your calculated difference is less than 0 (indicating more delay), route this potential Delay to a separate Time Type Group as Time Type Group Below, using 'Compare Threshold with Comparison Group to Route Input'. Remember to set up the Input Time Type Group with Reverse Sign since the difference is negative.
• If your calculated difference is more than 0 (indicating more Overtime), route this potential Overtime to a separate Time Type Group as Time Type Group Above. Use the same valuation type as above: 'Compare Threshold with Comparison Group to Route Input'.

With this setup, either the Time Type Group for real Delay or the real Overtime will be filled.

The different valuation types are described in more detail here: https://blogs.sap.com/2022/10/20/how-to-setup-time-evaluation-in-time-tracking/

I hope this helps! Let me know if you have any more questions.

Best Regards,

Hello Timo Biedenbender

Thanks for your support

I applied your solution it works fine but in case there is Delay with value 0 and Overtime with any value result will be delay same as overtime.

"Next, if your calculated difference is less than 0 (indicating more delay), route this potential Delay to a separate Time Type Group as Time Type Group Below, using 'Compare Threshold with Comparison Group to Route Input'. Remember to set up the Input Time Type Group with Reverse Sign since the difference is negative.""