Absence rate calculator
Calculate the absence rate as days lost divided by the days the team was scheduled to work.
Calculate the absence rate as days lost divided by the days the team was scheduled to work.
Absence rate = days lost ÷ (people × scheduled days per person) × 100.
Forty days lost across 50 people who were each scheduled for 220 days is 40 ÷ 11,000, which is 0.4%. The scheduled days are the days they were meant to work, not the calendar. Include only the absence your policy is measuring. Mixing sick leave with annual leave makes a rate you cannot compare with a sick-leave rate.
40 days lost. 50 × 220 = 11,000 scheduled days. 40 ÷ 11,000 × 100.
0.4%
40 ÷ (10 × 220) × 100.
1.8%
Not if you want a sickness or unplanned-absence rate. Holiday is scheduled. Put it in days lost only for a rate of all time away, and label it that way.
The absence rate treats ten separate days the same as one ten-day absence. The Bradford factor squares the number of spells, so the ten separate days score much higher. They answer different questions.
Count it as a fraction of a scheduled day if the rest of the team is in full days. An hours version, lost hours over scheduled hours, is cleaner when days have different lengths.
A planning figure for a conversation. It is not a payslip, a filing, or legal advice.