Team Absence Workload Formula
Learn how team capacity, workload shortfall, staffing need, and utilisation are calculated after expected absences.
This calculation estimates the staff hours a team can provide during a planning period after an expected absence rate is applied. It then compares available hours with planned work to show whether the workload fits within estimated capacity.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Available Team Capacity
Where:
First calculate all scheduled team hours, then reduce that total by the percentage of time expected to be lost to absences.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| teamSize - Team size | Number of people normally scheduled to work in the team. | people |
| workingDays - Working days | Scheduled working days in the selected planning period. | days |
| hoursPerDay - Hours per person per day | Average productive work hours for each person on a scheduled day. | hours |
| absenceRate - Expected absence rate | Percentage of scheduled work time expected to be unavailable. | percent |
| plannedWorkloadHours - Planned workload | Total staff hours of work required during the same period. | hours |
Step-by-Step Calculation
Convert the absence percentage
Convert the absence rate from a percentage to a decimal for use in the calculation.
absenceFactor = absenceRate / 100
Calculate scheduled team hours
This is the total capacity if everyone works every scheduled hour.
scheduledHours = teamSize * workingDays * hoursPerDay
Estimate absence hours
This estimates how many scheduled hours are unavailable because of absences.
absenceHours = scheduledHours * absenceFactor
Calculate available capacity
Subtract estimated absence hours from scheduled team hours.
availableHours = scheduledHours - absenceHours
Find the workload shortfall
A shortfall is shown only when planned work exceeds estimated available capacity.
workloadGap = max(plannedWorkloadHours - availableHours, 0)
Convert the gap to staffing equivalent
The gap is expressed as an average full-time-equivalent person for the selected period.
additionalFte = workloadGap / (workingDays * hoursPerDay)
Monthly team capacity calculation
Scheduled hours
10 × 22 × 8
1,760 hours
Absence factor
6 ÷ 100
0.06
Estimated absence hours
1,760 × 0.06
105.6 hours
Available capacity
1,760 − 105.6
1,654.4 hours
Workload shortfall
max(1,750 − 1,654.4, 0)
95.6 hours
Additional staffing needed
95.6 ÷ (22 × 8)
0.54 FTE
Final Result
Estimated capacity is 1,654.4 hours. A 1,750-hour workload produces a 95.6-hour shortfall, equivalent to approximately 0.54 additional FTE for the period.
Assumptions
- ✓The selected absence rate applies evenly across the whole planning period.
- ✓Each team member has the same scheduled working days and daily hours.
- ✓All remaining hours can be used for the planned workload.
- ✓The FTE result is an average for the period rather than a shift-by-shift staffing plan.
Limitations
- !The calculation does not account for specialist skills, role coverage, or whether people can substitute for one another.
- !It does not show when absences occur, so it may not identify daily or shift-level coverage gaps.
- !Actual productive time may differ because of meetings, handovers, travel, or changing work priorities.
- !A single absence rate may not reflect seasonal or unexpected changes in absence.
Common Mistakes to Avoid
Entering annual leave in the absence rate when it has already been excluded from working days.
Comparing workload hours from one period with capacity hours from another period.
Using paid hours when the workload requires productive delivery hours.
Treating an average FTE result as proof that a specific shift can be covered.
Assuming a zero workload gap means every role and skill requirement is covered.
Related Formulas
Frequently Asked Questions
How do you calculate team capacity after absences?
Multiply team size, working days, and hours per day, then multiply the result by one minus the absence rate as a decimal.
How is workload shortfall calculated?
Subtract available team capacity from planned workload. If the result is negative, the calculator reports a shortfall of zero.
What does 0.5 additional FTE mean?
It means the workload gap equals half of one full-time person's scheduled hours for the chosen period. It is an average capacity measure.
What does capacity utilisation above 100% mean?
It means planned workload is greater than estimated available capacity. For example, 110% indicates demand is 10% above capacity.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.