NMWM08144 - Working time: salaried hours work: excess hours calculation for pay reference periods for remainder of calculation year once basic hours exceeded: four-weekly example

Calculation for remaining pay reference periods in the calculation year

To calculate the hours to be treated as worked for National Minimum Wage purposes in pay reference periods following that in which the basic hours were first exceeded, all that is necessary is to add together:

  • the hours initially calculated using the basic hours (those hours have effectively already been worked prior to this point but have not yet been considered for National Minimum Wage); and
  • all the hours actually worked, or treated as worked (NMWM08100) in the pay reference period.

Top of page

Example: calculation in pay reference periods following that in which basic hours first exceeded

A four-weekly paid worker performing salaried hours work has a calculation year from 1 April 2019 to 31 March 2020 with 2080 basic hours (resulting in 13 four-weekly periods of 160 hours being treated as worked each pay reference period).

By 27 February the worker exceeded the basic hours.

In the four-week period commencing 2 March the worker worked 160 hours.

The hours treated as worked for period 13 will be;

Step Description Action Hours treated as worked
1. Hours calculated per basic hours (already worked prior to excess hours) - 160
2. Hours actually worked or treated as worked in the pay reference period + 160
- Total hours treated as worked = 320

The adjusted number of hours to be treated as worked in period 13 is 320 hours which is the sum of (1) 160 and (2) 160. This means that as a consequence of the excess hours the employer must increase the number of hours treated as worked for the purposes of National Minimum Wage from 160 to 320 hours.

This calculation is repeated in all remaining pay reference periods in the calculation year (in this example, there are no further complete four-weekly pay reference periods).

The annualised hours in a calculation year for a four-weekly paid worker are calculated using a divisor of 13 periods. However, a four-weekly calculation year may not fit exactly within the 13 four-week period used to ascertain the annual basic hours and so the four-weekly calculation year may start in the middle of a pay reference period or end after period 13.

In this example, the final two days of the calculation year, 30 and 31 March, is part of a four-weekly pay reference period that includes hours from two difference calculation years. The worker has worked 8 hours on 30 and 31 March and continues working into the new calculation year starting on 1 April 2020. Therefore, the worker must be paid for the excess hours treated as worked for the excess 16 hours worked on 30 and 31 March (effectively this means that the total hours treated as worked for the final day will be 32 hours (the original 16 basic hours of the calculation year plus the excess 16 hours actually worked)).

Unless a worker or employer varies their contract there will be no need to make any further calculations for the 1 April 2019 to 31 March 2020 calculation year. The employer must track cumulative totals from 1 April 2020 onwards to ensure that they can ascertain if, and when, the worker exceeds the basic hours for the calculation year 1 April 2020 to 31 March 2021. Hours worked on 30 and 31 March 2020 will not form part of that cumulative total for the calculation year 1 April 2020 to 31 March 2021.

Expanded form of this calculation (Excel 33k).