Relative Hours for Variable Employees
Determining relative hours for full days’ leave
Relative hours can be determined in different ways.
The standard way of determining relative hours is using the employees’ roster for the day.
Example: if employee was rostered 5 hours for the day, they will be deducted 1 days’ leave and paid 5 hours.
A non-standard way, which increases complexity and cost, is to use an averaging formula.
An averaging formula looks back over XX weeks and averages the hours worked or on paid leave on those days
Example: if averaging was looking at the past 4 weeks, if employee was sick on Monday, TimeFiler can look back at the past 4 Mondays and average the number of hours.
|
Mon 1 |
Mon 2 |
Mon 3 |
Mon 4 |
Total |
Average |
Relative Hours |
|
5 |
6 |
7 |
8 |
26 |
6.5 |
6.5 |
Note, the current day is not included in the 4-week test, week 1 is seven days prior to the current day, and week 4 is 28 days prior to the current day.
Determining relative hours for partial days’ leave
Relative hours for partial days can be determined in different ways.
Two standard ways of determining relative hours for partial days is outlined below.
-
Actual Hours taken: using the actual hours leave the employee has taken
Example: Employee is rostered 8 hours. They take 3 hours sick leave. Using actual hours as the relative hours, the employee will be paid:
-
Ordinary Time 5 hours
-
Sick leave 3 hours
-
Sick leave deducted from balance will be 0.5 day
-
Rostered hours multiplied by Leave Units: using the employee’s rostered hours for the day, and the unit of leave taken, to determine the relative hours
Example: Employee is rostered 8 hours. They take 3 hours sick leave, which equates to 0.5 day. Using rostered hours multiplied by leave units, this would calculate as:
8 hours * 0.5 = 4 hours.
The employee would be paid:
-
Ordinary Time 5 hours (this may be different depending on overtime rules, but they will be paid for 5 hours worked)
-
Sick leave 4 hours
-
Sick leave deducted from balance will be 0.5 day
A non-standard way, which increase complexity and therefore cost, is using an averaging formula combined with multiplying by leave units.
This would look at the past XX weeks to obtain an average number of hours for that day, and then multiplying that average by the leave units taken Example:
|
Mon 1 |
Mon 2 |
Mon 3 |
Mon 4 |
Total |
Average |
Partial day taken |
Relative Hours |
|
5 |
6 |
7 |
8 |
26 |
6.5 |
0.5 |
3.25 |
The effect of relative hours on partial days’ leave and overtime
Employees can sometimes be paid a partial days’ leave and overtime on the same day. The formula used to calculate relative hours for partial days will determine if overtime may apply.
Example: Employee is rostered for 8 hours. They take 3 hours sick leave and work 5 hours.
Using the ‘Actual Hours Taken’ formula for determining the relative hours, results in:
-
Ordinary Time/Overtime 5 hours
-
Sick Leave 3 hours
-
Sick leave deducted from balance will be 0.5 day
Using the ‘Rostered hours multiplied by leave units’ formula for determining the relative hours, results in an additional overtime payment:
-
Ordinary Time/Overtime 5 hours
-
Sick Leave 4 hours
-
Sick leave deducted from balance will be 0.5 day
Determining the quantity of leave deducted
Customers who deduct leave in days can derive the quantity of a ‘day’ or ‘partial day’ in many different ways.
Example 1: quantities in either 0.5 or 1 day
Example 2: actual daily quantity e.g. 0.27 of a day
Example 3: quantities in quarter days e.g. 0.25, 0.50, 0.75 or 1.00
Example 4: maximum of 1 day leave deducted. This is relevant when two leave types are taken on one day e.g. if employee takes 2 hours of one leave type and 6 hours of another leave type, this could result in both ½ day and 1 day being deducted.
There is a separate IMS Online Customisation document called ‘Daily Leave Rounding’ that explains this in more detail and is available as an additional customisation.
Generally, customers install both Daily Leave Rounding and Variable Hours customisations when they have variable hours’ employees and daily leave values.
Order customisation
Please complete the IMS Online Customisation order form to arrange to have relative hours functionality installed.
We will discuss your requirements with you so the costs can be determined.
