Overtime Rounding

Created by rotcana Choong, Modified on Sun, 7 Jun at 4:39 PM by rotcana Choong

Print


Overtime Rounding is a setting maintained in Rule Maintenance that determines how overtime (OT) hours are rounded before being used for attendance and payroll calculations. 

There are three rounding options available: No RoundingRound Up, and Round Down, with selectable time intervals including 5, 15, 30, 45 minutes, or 1 hour.

Calculation:

  • Overtime Worked Hours = Total Worked Hours − Shift Working Hours

  • Acceptable Overtime Worked Hours = Overtime Worked Hours − Excluded Overtime Hours

  • Final overtime hours are then adjusted based on the selected rounding rule.



Scenario Example:

  • Shift Time: 10:00 AM – 4:00 PM

  • Break: 1 hour

  • OT Rounding: Round Up 

  • Rounding Time: 15 minutes

  • Clock In: 10:36 AM

  • Clock Out: 5:48 PM

Calculation:

  • Total Worked Hours: 5:48 pm - 10:36 am = 7 hours 12 minutes

  • Overtime Worked Hours: 

Total Worked Hours - Shift Working Hours 

= 7.2 hours - 5 hours 

= 2 hours 12 minutes

  • Excluded Time: 

Before Shift Time + Break Time = 0 hour + 1 hour = 1 hour

  • Acceptable OT:

2.2 hours - 1 hour = 1.2 hours

  • Rounded Up (15 mins) = 1 hour 15 minutes


Note: Go to Human Resource > Attendance Transaction. Click Scenario to view the calculation details.