Custom column to exclude Time Off hours in Pay Rate calculation

Find resources designed to help you get the most from Replicon

To generate a column that will show the Amount for Total Hours a person has worked against his Base Payroll Rate. This calculation should not take into consideration the number of hours for any time off type.

Create a Report with the required columns. In the custom column, provide the below given formula: 


The above formula takes advantage of the fact that all time off types fall under ' <None> ' Project Name. So whenever the formula encounters no project name, it will not multiply the hours with base pay roll rate.

Start a free Replicon trial today based on your business needs

Start Free Trial