Understanding the absence percentage calculator — concept and principle
This calculator turns absent days into an absence rate, the share of scheduled working time lost, plus attendance rate, days per employee, hours lost and pay cost. HR teams and managers use it to track unplanned absence and compare teams of different sizes fairly.
How it is calculated
- Scheduled days = number of employees × scheduled working days per employee
- Absence rate (%) = total days absent ÷ scheduled days × 100
- Attendance rate (%) = 100 − absence rate
- Average days absent per employee = total days absent ÷ employees
- Working hours lost = days absent × hours per working day
- Pay cost of absent days = days absent × pay cost per employee per day
Count only days people were expected to work. Booked holidays, public holidays and weekends are not absences and should not be in either number.
The principle
A raw count is hard to compare: 120 days means something different in a team of 10 than in a team of 200. Dividing by scheduled time gives a rate comparable across teams and periods. The U.S. Bureau of Labor Statistics uses the same idea in hours, the lost worktime rate: hours absent as a percentage of hours usually worked.
Worked example
Defaults: 25 employees, 230 scheduled working days each, 120 days absent, 8 hours per day, pay cost 200 per employee per day.
- Scheduled days = 25 × 230 = 5,750.
- Absence rate = 120 ÷ 5,750 × 100 = 2.09%.
- Attendance rate = 100 − 2.09 = 97.91%.
- Average days absent = 120 ÷ 25 = 4.8 days per employee.
- Hours lost = 120 × 8 = 960.
- Pay cost = 120 × 200 = $24,000.
| Number of employees | Absence rate |
|---|---|
| 6.25 | 8.35% |
| 12.5 | 4.17% |
| 18.8 | 2.78% |
| 25 | 2.09% |
| 31.2 | 1.67% |
| 37.5 | 1.39% |
| 50 | 1.04% |
How to read the result
Compare with your own past periods first. The BLS reported a lost worktime rate of 1.9% for US full-time wage and salary workers in 2021, a rough reference, not a target. A rising trend or one team far above the rest says more than a single number.
Common mistakes
- Counting holidays or weekends as absence, which inflates the rate.
- Using calendar days instead of scheduled working days.
- Treating part-time staff as full-time employees; use full-time equivalents.
- Taking the pay cost as the full cost. Overtime, temporary cover and lost output usually add to it.
Frequently asked questions
What is a normal absence rate?
It varies by sector and country. US BLS data for 2021 put the lost worktime rate for full-time workers at 1.9%, so a few percent is common.
Should long-term sickness be included?
Include it if it was unplanned absence from scheduled work, but also look at it separately so it does not hide short-term patterns.
How is this different from the Bradford factor?
The absence rate measures total time lost. The Bradford factor weights frequent short spells more heavily.
Sources: U.S. Bureau of Labor Statistics, Current Population Survey, Table 47 "Absences from work of employed full-time wage and salary workers by occupation and industry", 2021 annual averages