Custom column for calculating Holiday Overtime based on Work Hours

Find resources designed to help you get the most from Replicon

  Calculating Holiday Overtime Hours based on certain conditions using the Timesheet Detail Report

  Conditions for the Overtime Calculation :
If user works on a Holiday, the total hours worked should by multiplied by 2.5.
If user does not work on a Holiday, the populated hours should be shown as it is.

  Custom column created to satisfy above condition in Timesheet Detail Report :

IF (TimeOffName="<DefaultTimeoffTypeName>",(PayrollOnlyHours*2.5),TimeOffHours)
  where 1) <DefaultTimeoffTypeName> is the Time off Type Name set as Default in Time off Types. Ex : "Holiday" or "Standard Holiday"
           2)  PayrollOnlyHouors = Hours Worked
           3)  TimeOffHours = Time off Hours automatically populated due to holiday

Start a free Replicon trial today based on your business needs

Start Free Trial