Absence Rates Rate (Team) Calculator
Calculate your team's absence rate from the number of employees, scheduled working days, and total days absent.
Overview
This team absence rate calculator estimates the percentage of scheduled working time lost to absence in a selected period. Enter your average team size, scheduled working days per employee, and the total number of absence days recorded.
How it works
The calculator first multiplies the number of team members by the scheduled working days per employee to find total scheduled team days. It then divides total absence days by those scheduled days and multiplies the result by 100. For example, 10 absence days from 200 scheduled team days gives an absence rate of 5%.
How to use this calculator
- 1Choose a reporting period, such as a month, quarter, or year.
- 2Enter the average number of people in the team during that period.
- 3Enter the scheduled working days for each employee.
- 4Add the total qualifying absence days for the whole team.
- 5Review the absence rate alongside the attendance rate and days worked.
Example Calculation
Number of team members
10
Scheduled working days per employee
22
Total absence days
8
Team absence rate
3.64%
A team of 10 people scheduled for 22 days each has 220 scheduled team days. With 8 absence days, the absence rate is approximately 3.64% and the attendance rate is approximately 96.36%.
Frequently asked questions
How is team absence rate calculated?
Team absence rate equals total absence days divided by total scheduled working days, multiplied by 100. Scheduled working days are usually team size multiplied by scheduled days per employee.
What absence days should I include?
Include the absence categories your organisation tracks for the metric, such as sickness or unauthorised absence. Use the same policy for every period so results can be compared fairly.
Should annual leave be included in absence rate?
Annual leave is normally planned time away rather than absence, so it is often excluded. Follow your organisation's reporting definition and ensure scheduled days are adjusted consistently where needed.
What is a good absence rate for a team?
There is no single suitable rate for every workplace. Compare results with the team's own historical pattern, workforce mix, seasonality, and the organisation's defined benchmarks.
Can I use this calculator for part-time employees?
Yes, provided the scheduled working days figure reflects the relevant contracted schedule. For teams with very different schedules, using total scheduled team days from timesheet or rota records may be more accurate.
Why can an absence rate be above 100%?
A rate above 100% usually means more absence days were entered than scheduled team days. Check the reporting period, team size, schedules, and whether absence totals were counted more than once.
Explore Related Calculators
Assumptions and warnings
Assumptions
- The reporting period is the same for the scheduled days and absence-day totals.
- Each team member is assumed to have the same number of scheduled working days.
- Absence rate is calculated as total absence days divided by total scheduled team working days.
- The calculation does not distinguish between absence types, such as sickness, authorised leave, or unpaid absence.
Warnings
- This calculator provides a general workforce metric only. Apply your organisation's absence policy consistently when deciding which days to include.
- Check that absence days do not exceed scheduled working days, as this can produce an unrealistic result.