Formula : How to set the lateness formula using IF ELSE function in deduction?

Created by rotcana Choong, Modified on Sat, 6 Jun at 7:55 PM by rotcana Choong

Print

This setup is used to create a deduction based on employee lateness duration, where different deduction amounts are applied depending on how late the employee is.


Step to Set Lateness Formula using IF ELSA Function in Deduction:

  1. Go to Tools > Payroll Items.

  2. Go to Deduction.


  1. Click + Add New.


  1. Enter the Code, Description and determine the settings.

  2. Enter the formula as below. 

  • IF (Lateness Time <= 30 AND Lateness Time < 60) 100 ELSE IF (Lateness Time >= 60 AND Lateness Time < 90) 200 ELSE 0


  1. Click Save.


  1. Ensure Lateness Time has been properly extracted in Time Attendance Import.


  1. Process the employee’s payroll. The deduction should be reflected.