Absence Rates and Utilisation Formula
Learn how to calculate employee absence rate, remaining available hours, attendance rate and workforce capacity utilisation.
This calculator measures scheduled workforce capacity, removes time lost to absence, and compares productive hours with the capacity that remains. It helps keep absence and utilisation measures separate, so a team can see whether low output is linked to lost attendance, unused available time, or both.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Capacity utilisation rate
Where:
Divide productive hours by the scheduled hours left after absences, then multiply by 100 to express the share of available capacity used productively.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| E - employeeCount | Average number of employees included in the reporting period. | number |
| D - scheduledDaysPerEmployee | Scheduled workdays for each employee during the period. | days |
| H - hoursPerWorkday | Standard scheduled working hours in one workday, excluding unpaid breaks. | hours |
| A - absenceDays | Total employee-days lost to recorded absence. | days |
| P - productiveHours | Hours recorded as productive, value-adding work in the same period. | hours |
| AH - availableHours | Scheduled hours remaining after absence hours are removed. | hours |
Step-by-Step Calculation
Calculate scheduled employee-days
This is the total number of employee workdays planned across the group.
scheduledEmployeeDays = employeeCount * scheduledDaysPerEmployee
Calculate scheduled hours
Convert all planned employee-days into scheduled workforce hours.
scheduledHours = scheduledEmployeeDays * hoursPerWorkday
Convert absence days to absence hours
Use the standard workday length to express lost time in hours.
absenceHours = absenceDays * hoursPerWorkday
Calculate the absence rate
This shows the percentage of scheduled employee-days lost to absence.
absenceRate = (absenceDays / scheduledEmployeeDays) * 100
Calculate hours available after absence
Subtract absence hours from total scheduled hours. The minimum result is zero.
availableHours = max(0, scheduledHours - absenceHours)
Calculate attendance rate
This is the share of scheduled hours that remained after absences.
attendanceRate = (availableHours / scheduledHours) * 100
Calculate capacity utilisation
Compare productive hours with the hours available after absence.
utilisationRate = (productiveHours / availableHours) * 100
Calculate unutilised available hours
This estimates available hours that were not recorded as productive work.
unutilisedHours = max(0, availableHours - productiveHours)
Worked example: 25 employees over a monthly period
Scheduled employee-days
25 × 22
550 employee-days
Scheduled hours
550 × 8
4,400 hours
Absence hours
20 × 8
160 hours
Absence rate
(20 ÷ 550) × 100
3.6%
Available hours after absence
4,400 − 160
4,240 hours
Capacity utilisation
(3,600 ÷ 4,240) × 100
84.9%
Unutilised available hours
4,240 − 3,600
640 hours
Final Result
The absence rate is 3.6%, attendance rate is 96.4%, and 3,600 productive hours represent 84.9% utilisation of 4,240 available hours.
Assumptions
- ✓Each included employee is assumed to have the same scheduled workdays and standard hours per day.
- ✓Absence days are full employee-day equivalents; partial-day absences should be converted to fractions of a day.
- ✓Productive hours and absence days cover the same reporting period and employee group.
- ✓The productive-hours definition is applied consistently across the workforce.
- ✓Overtime, temporary cover and staffing changes are excluded unless they are reflected in the entered figures.
Limitations
- !Different shift patterns, part-time schedules and compressed workweeks may make one standard workday length less representative.
- !The calculation does not distinguish between sickness, authorised leave, unauthorised absence or other absence categories.
- !A utilisation percentage cannot show the quality, value or complexity of the work completed.
- !Productive hours above available scheduled hours can produce utilisation above 100%, which needs context rather than automatic interpretation.
- !Results depend on accurate time, attendance and productive-hours records.
Common Mistakes to Avoid
Using calendar days rather than scheduled workdays per employee.
Entering individual absence days instead of total absence days for the full group.
Including productive hours from a different team or reporting period.
Treating planned annual leave as absence without applying the same capacity treatment consistently.
Using paid hours, rather than productive hours, as the numerator for utilisation.
Ignoring part-time staff or shift patterns when choosing standard hours per workday.
Related Formulas
Frequently Asked Questions
What is the employee absence rate formula?
Absence rate equals total absence days divided by scheduled employee-days, multiplied by 100. Scheduled employee-days equal employee count multiplied by scheduled workdays per employee.
How is workforce capacity utilisation calculated after absence?
Divide productive hours by available hours after absence and multiply by 100. Available hours are scheduled hours less absence hours.
Is attendance rate the opposite of absence rate?
When both use the same scheduled capacity and absence definition, attendance rate is generally 100% minus absence rate. This calculator calculates attendance from available and scheduled hours.
Why might utilisation be more than 100%?
It can happen if productive hours include overtime, temporary-worker hours, or work outside the scheduled capacity entered. It can also point to inconsistent source data.
What happens if available hours are zero?
Utilisation cannot be meaningfully calculated when no hours remain available. Review the scheduled hours, absence days and productive-hours inputs.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.