Public Holiday Pay

How do I calculate the hours owed for a Public Holiday Pay

Mark Borham avatar
Written by Mark Borham
Updated over a week ago

Important: Public Holidays can be created en masse or individually in the Scheduler. Public Holidays can also be created in the timesheets directly. To create a public holiday for one employee, create a time-off and select the "Automatic" calculation option.

You can set a rule when creating a time off to calculate the Public Holiday Pay for each employee. You can set the rule while creating time offs in bulk.

This feature is only available for Time & Attendance users.

Create a Public Holiday in the Scheduler

A) Bulk Time Off Creation

You must first open the bulk time off creation window situated in the "More" button top right of the agenda.

How to proceed when your employees are assigned to more than one location

In order to create the time off only once per employee when they are assigned to multiple locations, you have to select the '' Employee with this main location'' filter.

Therefore, if you have 6 different locations, you need to create 6 time offs using the bulk action with the ''Employees with this main location'' filter selected.

If you do not select the filter, the time off will be created for all locations assigned to your employees which will result in multiple time offs for each employee with more than one location.


B) Date and Time Off type

  1. Select the date when you will pay the Public Holiday

  2. Select the correct Time Off type


C) Calculation Rule

  1. Select automatic hours calculation method

  2. Select the date range that must be accounted for

Hours calculation

  1. You can choose to divide worked hours by a predetermined number of days (i.e. 20)

  2. You can choose to divide worked hours by the number of days the employee worked during the interval

For example, in ON and QC, you must choose the proceeding 4 weeks and divide by 20 days.
In BC, you will want to divide hours worked in the past 30 days by the number of days the employee worked. But the system won't detect if the employee worked less than 15 days in the past 30 days. So you'll need to delete manually time entries that are not qualified.


D) Reporting to Timesheet

Upon the day of the Public Holiday, Agendrix will automatically create a time entry for each employee targeted. Only at that time will the number of hours be calculated

Extra tip: If you forgot to create the public holiday in advance, you can always create it manually under the timesheets!

The next time you export the payroll, the column "Public holiday" will show the number of hours resulting from the hours worked and the rule that you have set.

Did this answer your question?