Work & pay

Workforce Absenteeism Rate Calculator

Measure lost scheduled time against total scheduled time in matching units. Decide which absence categories belong in the comparison; the result does not assess an individual's circumstances.

Runs privately in your browserMethod reviewed

Your numbers

Your figures stay on this device.

How the calculation works

Absenteeism rate expresses lost scheduled time as a share of the time that should have been worked. It measures duration rather than the number of separate absence spells, and requires matching units and a consistent population.

Absence rate = lost scheduled time ÷ total scheduled time × 100.
  1. Define which absence is included

    Establish the categories and review period before adding the records. The tool does not classify leave or decide which categories belong in an employer’s metric.

  2. Match the denominator

    Total the scheduled hours or days for that same population and time span. A denominator from another team or period would measure a different exposure.

  3. Express lost time as a percentage

    Divide included absence time by scheduled time and multiply by one hundred. Zero lost time returns zero percent, while the validation prevents a rate above 100% from inconsistent inputs.

Worked example: Two per cent

Sample inputs demonstrate the method. They are not a forecast or product offer.

The first example enters 80 lost units and 4,000 scheduled units on the same basis. Dividing 80 by 4,000 gives 0.02, or 2%. The ratio would be identical whether both inputs represented hours or both represented comparable days.

Absence hours or days
80
Total scheduled hours or days
4000

Expected result

Absence rate
2%
Worked example: No absence

Sample inputs demonstrate the method. They are not a forecast or product offer.

Absence hours or days
0
Total scheduled hours or days
200

Expected result

Absence rate
0%

Understanding your result

The percentage shows the share of scheduled time lost under the chosen definition. It does not reveal how that time was distributed across people or how many separate episodes occurred.

Comparisons need consistent absence categories and work-time units. This descriptive measure cannot assess individual circumstances or justify a disciplinary response.

Questions you might have

What does this absenteeism rate calculator include?

Measure the share of scheduled work time lost to absence using hours or days consistently.

Which assumptions should I check?

Use matching units and the same staff population and period. Decide which absence categories are included before comparing teams; this is not a disciplinary recommendation.

Choosing the right inputs

Absence hours or days
Enter the included absence time in hours or days under your chosen definition. It must be non-negative and cannot exceed the scheduled time entered.
Total scheduled hours or days
Use positive total scheduled time for the same employees and period. Match its unit to the absence input; hours are often clearer when working-day lengths differ.

Common mistakes to avoid

  • Do not divide absent days by scheduled hours.
  • Counting the same absence once in each of two overlapping categories will overstate lost time; reconcile the underlying records before entry.

Assumptions to check

  • Use matching units and the same staff population and period. Decide which absence categories are included before comparing teams; this is not a disciplinary recommendation.

Sources and method

Read our calculation and testing approach.