Absence Rates Capacity Formula
Learn how to estimate available staff hours and staff-equivalent capacity after applying an expected absence rate.
The absence rates capacity formula adjusts scheduled workforce time for expected non-availability. It helps planners estimate how many hours may remain usable over a period before considering workload, skills, or shift-specific coverage.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Available Capacity Hours
Where:
First calculate all scheduled hours. Then keep the percentage of time not expected to be lost to absence.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| scheduledStaff - Scheduled staff | Number of employees scheduled to work in the planning period. | people |
| hoursPerStaffPerDay - Hours per staff member per day | Average scheduled work hours for each employee on a working day. | hours |
| workingDays - Working days in period | Number of workdays included in the plan. | days |
| absenceRate - Expected absence rate | Expected share of scheduled time that will be unavailable because of absence. | percent |
Step-by-Step Calculation
Calculate scheduled hours
Multiply the number of scheduled people by average daily hours and the number of working days.
scheduledHours = scheduledStaff * hoursPerStaffPerDay * workingDays
Convert the absence rate
Convert the percentage to a decimal so it can be used in the calculation.
absenceFactor = absenceRate / 100
Estimate lost hours
Apply the absence factor to total scheduled hours to estimate unavailable time.
lostHours = scheduledHours * absenceFactor
Calculate available hours
Subtract expected lost hours from total scheduled hours.
availableHours = scheduledHours - lostHours
Calculate staff-equivalent capacity
Reduce scheduled headcount by the expected absence share to show average full-period staff-equivalent capacity.
availableStaffCapacity = scheduledStaff * (1 - absenceFactor)
Weekly capacity for a 25-person team
Scheduled hours
25 * 8 * 5
1,000 hours
Absence factor
6 / 100
0.06
Estimated lost hours
1,000 * 0.06
60 hours
Available capacity hours
1,000 - 60
940 hours
Available staff capacity
25 * (1 - 0.06)
23.5 staff equivalents
Final Result
Estimated available capacity: 940 hours, equivalent to 23.5 staff equivalents.
Assumptions
- ✓The expected absence rate applies evenly across the workforce and the planning period.
- ✓All scheduled employees are represented by the same average daily hours.
- ✓Absence is measured as a percentage of scheduled time.
- ✓The calculation adjusts for absence only, not work output or task complexity.
Limitations
- !Actual absence may be higher or lower than the expected rate.
- !The result does not show whether required skills are available on each shift.
- !A staff-equivalent figure can mask uneven absence across days, teams, or locations.
- !The calculation does not include overtime, agency cover, vacancies, breaks, or productivity differences unless reflected in the inputs.
Common Mistakes to Avoid
Entering 6 as 0.06 when the input expects a percentage; enter 6% as 6.
Using calendar days instead of the working days actually scheduled.
Treating staff-equivalent capacity as the number of people guaranteed to be present at one time.
Combining teams with very different shift lengths into one average when separate calculations would be clearer.
Using an absence rate that includes time already removed from the schedule, which can double-count planned non-availability.
Related Formulas
Frequently Asked Questions
What is the formula for capacity after absence?
Available hours equal scheduled staff multiplied by daily hours and working days, then multiplied by one minus the absence rate divided by 100.
How are lost hours from absence calculated?
Lost hours equal total scheduled hours multiplied by the expected absence rate as a decimal.
What does staff-equivalent capacity mean?
It is the average full-period workforce capacity remaining after expected absence. It is not necessarily the number of people present at a particular moment.
Does the formula include annual leave and training?
It can if those forms of non-availability are included in the absence rate you choose. Use a definition that matches your planning purpose.
Should I calculate separate absence rates for different teams?
Separate calculations can be more useful when teams have different hours, shift patterns, roles, or absence histories.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.