Absence Rate Hours Formula

Learn how to calculate an employee absence rate from total absence hours and scheduled working hours.

An hours-based absence rate shows the share of scheduled work time recorded as absence during a selected period. It provides a consistent percentage for reviewing periods or groups when the same date range and recording definitions are used.

100% Free
No Sign-Up Required
Private & Secure
Mobile Friendly

Absence rate

Absence rate = (Total absence hours ÷ Total scheduled hours) × 100

Where:

First find the group’s total scheduled hours. Then divide absence hours by those scheduled hours and multiply by 100 to express the result as a percentage.

Variables Explained

Variable	What It Means	Unit
numberOfEmployees - Number of employees	The average number of employees included in the calculation period.	number
scheduledHoursPerEmployee - Scheduled hours per employee	The working hours each employee was expected to work during the period.	hours
totalAbsenceHours - Total absence hours	All recorded absence hours for the included employees during the same period.	hours
totalScheduledHours - Total scheduled hours	The expected working hours for the whole group during the period.	hours
absenceRate - Absence rate	The percentage of scheduled hours that were recorded as absence.	percent

Step-by-Step Calculation

Set the calculation scope

Use one defined group of employees and one consistent reporting period.

numberOfEmployees > 0

Calculate total scheduled hours

Multiply the employee count by the scheduled hours per employee.

totalScheduledHours = numberOfEmployees * scheduledHoursPerEmployee

Calculate the absence proportion

Divide recorded absence hours by the total expected hours.

absenceProportion = totalAbsenceHours / totalScheduledHours

Convert the proportion to a percentage

Multiply by 100 to show the absence share as a percentage.

absenceRate = absenceProportion * 100

Calculate average absence per employee

This supporting measure spreads total absence hours across the employees included.

averageAbsenceHoursPerEmployee = totalAbsenceHours / numberOfEmployees

Calculate attendance rate

Attendance rate is the percentage of scheduled hours not recorded as absence.

attendanceRate = 100 - absenceRate

Monthly absence rate for a 20-person team

Number of employees20 employees

Scheduled hours per employee160 hours

Total absence hours64 hours

Calculate total scheduled hours

20 × 160

3,200 hours

Calculate absence proportion

64 ÷ 3,200

0.02

Convert to absence rate

0.02 × 100

2.00%

Calculate average absence per employee

64 ÷ 20

3.20 hours

Calculate attendance rate

100% − 2.00%

98.00%

Final Result

The absence rate is 2.00%, based on 64 absence hours out of 3,200 scheduled hours. The attendance rate is 98.00%.

Try the Calculator →

Assumptions

✓All employees are treated as having the same scheduled hours for the selected period.
✓Employee count, scheduled hours, and absence hours cover the same people and dates.
✓All recorded absence hours are treated equally regardless of their reason or duration.
✓The total scheduled hours are greater than zero.

Limitations

!The result measures hours lost, not the number of absence episodes or their causes.
!Different shift patterns, joiners, leavers, and part-time schedules may require more detailed employee-level data.
!Results cannot be compared reliably when teams use different absence definitions or recording practices.
!An absence rate does not measure operational impact, service levels, or staffing cover.

Common Mistakes to Avoid

Using absence hours from a different date range than the scheduled hours.

Entering individual scheduled hours when the field requires the hours for each employee.

Including employees in the headcount who were not included in the absence records.

Counting planned leave in one period but excluding it in another without noting the change.

Dividing absence hours by hours actually worked rather than scheduled hours.

Treating an average absence per employee as the absence rate percentage.

Related Formulas

Absence Rates Hours (Individual) Calculator FormulaCalculate an individual employee's absence rate from scheduled working hours and hours absent ove...View formula →Absence Rates Hours (Team) Calculator FormulaCalculate your team’s absence rate from total scheduled working hours and recorded absence hours.View formula →Absence Rates Hours (Annual) Calculator FormulaCalculate an annual employee absence rate from total absence hours and contracted working hours.View formula →Absence Rates Capacity Calculator FormulaEstimate the staff and working hours available after allowing for an expected employee absence ra...View formula →

Frequently Asked Questions

What is the formula for absence rate by hours?

Divide total absence hours by total scheduled hours, then multiply by 100. Total scheduled hours equal employee count multiplied by scheduled hours per employee.

How do I calculate total scheduled hours?

Multiply the number of employees included by the scheduled hours per employee for the same period.

How is attendance rate calculated from absence rate?

Subtract the absence rate from 100%. For example, a 2% absence rate corresponds to a 98% attendance rate.

Can an hours-based absence rate be used for a week or a year?

Yes. Use one consistent period and make sure all inputs relate to that same period.

Why can an absence rate exceed 100%?

It usually indicates that absence hours exceed the scheduled hours entered or that the inputs use different groups, schedules, or dates.

Ready to calculate your result?

Use the calculator to get instant results with your own inputs.

Try Absence Rate Hours→