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 :
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