Team Absence Capacity Formula
Learn how to calculate available team hours, workdays, and average staffing after an expected absence rate is deducted.
This calculation estimates the capacity a team is likely to have during a planning period after allowing for expected absences. It starts with scheduled team hours, estimates time lost to absence, and shows the remaining hours and equivalent workdays for workload planning.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Available Team Capacity
Where:
Multiply the team's scheduled hours by the percentage expected to remain available after absences.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| teamSize - Team size | The number of people included in the team. | people |
| periodWeeks - Planning period | The number of weeks being estimated. | weeks |
| workingDaysPerWeek - Working days per week | Usual scheduled workdays per person each week. | days |
| hoursPerDay - Working hours per day | Scheduled hours in a typical workday for each person. | hours |
| absenceRate - Expected absence rate | The percentage of scheduled time expected to be unavailable because of absence. | percent |
Step-by-Step Calculation
Calculate scheduled team workdays
This gives the total number of workdays scheduled for the whole team before absences.
scheduledWorkdays = teamSize * periodWeeks * workingDaysPerWeek
Calculate gross scheduled hours
Convert scheduled team workdays into total scheduled hours.
grossCapacityHours = scheduledWorkdays * hoursPerDay
Estimate absence hours
Apply the expected absence percentage to gross scheduled hours.
absenceHours = grossCapacityHours * absenceRate / 100
Calculate available team capacity
Subtract estimated absence hours from gross scheduled hours.
netCapacityHours = grossCapacityHours - absenceHours
Convert available hours to workdays
Express remaining capacity as equivalent full workdays.
netCapacityDays = netCapacityHours / hoursPerDay
Estimate average available staffing
This expresses expected availability as an average full-time-equivalent number of people.
averageAvailablePeople = teamSize * (1 - absenceRate / 100)
Worked example: 10-person team over four weeks
Scheduled team workdays
10 * 4 * 5
200 days
Gross scheduled capacity
200 * 8
1,600 hours
Expected absence time
1,600 * 5 / 100
80 hours
Available team capacity
1,600 - 80
1,520 hours
Available workdays
1,520 / 8
190 days
Average available team members
10 * (1 - 5 / 100)
9.5 people
Final Result
Estimated available capacity: 1,520 hours, or 190 workdays, with average staffing equivalent to 9.5 people.
Assumptions
- ✓The absence rate is applied evenly across the team and the planning period.
- ✓Every team member is assumed to have the same working days and hours.
- ✓All scheduled hours are treated as available capacity before absence is deducted.
- ✓The absence percentage represents expected lost scheduled time for the selected period.
Limitations
- !Actual absences may be concentrated in particular roles, days, or weeks rather than spread evenly.
- !The calculation does not automatically deduct public holidays, annual leave, meetings, training, vacancies, or non-productive time.
- !A team with substantially different individual schedules may need separate calculations for each work pattern.
- !Available hours do not necessarily equal deliverable output because tasks can require different skills, dependencies, or levels of effort.
Common Mistakes to Avoid
Entering an absence rate as a decimal such as 0.05 when the input expects 5%.
Using standard working days when public holidays or planned closures reduce the period's schedule.
Including annual leave in both the absence rate and a separate schedule adjustment.
Treating net capacity as time that can all be assigned to project work without allowing for meetings or routine duties.
Using one average schedule for a team with widely different part-time or shift patterns.
Related Formulas
Frequently Asked Questions
What is the formula for team capacity after absence?
Available capacity equals team size multiplied by weeks, working days per week, and hours per day, then multiplied by one minus the absence rate divided by 100.
How do I calculate absence hours for a team?
Multiply gross scheduled team hours by the expected absence rate and divide by 100.
How are available workdays calculated?
Divide available team hours after absence by the scheduled hours per workday.
What does average available team members mean?
It is a full-time-equivalent estimate of team availability after the absence percentage is deducted. It does not mean the same individuals will be absent throughout.
Should annual leave be included in the absence rate?
Include it only if your absence percentage is intended to cover planned leave. Avoid counting the same leave time twice.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.