Absence Rate Formula: How to Calculate It Correctly

The absence rate is the percentage of scheduled working time that employees actually miss. It is the single most portable absence metric you have: it works for one person, one team, or an entire company, and it lets you compare a five-person startup against a national benchmark without distortion.

Most HR teams get the numerator right and the denominator wrong. That is where absence reporting quietly breaks. This guide gives you the absence rate formula, three worked examples at different levels, the part-time adjustment almost everyone skips, and an honest answer to “what is a good absence rate?”

Key Takeaways

• Absence rate = (days lost ÷ days available) × 100. The denominator is scheduled working days, not calendar days.
• The UK sickness absence rate was 2.6% in 2022, the highest since 2004, per the ONS.
• Use hours instead of days once part-time staff are in the mix, or your rate will overstate absence.
• Absence rate measures volume. The Bradford Factor measures frequency. You need both.

What Is the Absence Rate?

The absence rate is the proportion of available working time lost to absence, expressed as a percentage. It answers one question: out of all the time we expected people to be at work, how much did we lose?

It is sometimes called the lost time rate. Both names describe the same calculation. Unlike raw absence days, the absence rate is scale-independent, so a team of 6 and a company of 600 produce numbers you can put side by side.

You choose what counts as absence before you calculate. Most organisations count unplanned absence only: sickness, unauthorised absence, and emergency dependant leave. Approved annual leave is normally excluded, because it is planned time off you have already budgeted for.

What Is the Absence Rate Formula?

The standard formula is:

Absence rate (%) = (Total days lost to absence ÷ Total available working days) × 100

Two rules make or break the result:

1. The denominator is scheduled working days, not calendar days. A full-time employee in a five-day week has roughly 260 scheduled days a year before public holidays, not 365.
2. The period must match on both sides. If you count absence days for a quarter, count available days for that same quarter.

If you track absence in hours, the formula is identical in shape:

Absence rate (%) = (Total hours absent ÷ Total scheduled hours) × 100

How Do You Calculate Absence Rate for One Employee?

Start with the individual, because every other level is built from it.

Priya works a standard five-day week. Over the year she is scheduled for 260 working days. She takes 12 days of sick leave across four separate spells. Her annual leave is excluded.

• Days lost = 12
• Available working days = 260
• 12 ÷ 260 = 0.04615
• 0.04615 × 100 = 4.62%

Priya’s absence rate is 4.62%. Note what the number does not tell you: whether that was one long recovery or twelve scattered single days. Volume alone hides pattern.

How Do You Calculate Absence Rate for a Team?

For a team, multiply headcount by the working days in the period, then divide total team absence by that figure.

A support team has 8 full-time people. In the quarter there are 63 scheduled working days per person after public holidays. Across the quarter the team loses 21 days to sickness.

• Available days = 8 × 63 = 504
• Days lost = 21
• 21 ÷ 504 = 0.04166
• 0.04166 × 100 = 4.17%

The team is running at 4.17% for the quarter. Comparing that against your other teams is usually more useful than comparing it against a national average, because your teams share the same policy, the same sick pay scheme, and the same recording habits.

How Do You Calculate Absence Rate for the Whole Company?

Company-level absence rate uses the same formula with aggregate figures.

A company employs 120 people, all full-time, in a month with 21 working days. Total recorded absence for the month is 88 days.

• Available days = 120 × 21 = 2,520
• Days lost = 88
• 88 ÷ 2,520 = 0.03492
• 0.03492 × 100 = 3.49%

Track this monthly rather than annually. A yearly figure smooths out exactly the spikes you needed to see, a point we cover in more depth in our guide to spotting absence trends with leave analytics.

Adjusting for Part-Time Staff

Headcount-based denominators break as soon as your workforce is mixed. Someone working three days a week cannot lose five days in a week, but a headcount formula assumes they can.

You have two clean fixes:

• Switch to hours. Divide hours absent by hours scheduled. This is the most accurate method and the one to use if your rota varies.
• Weight the denominator by FTE. If 120 people represent 96.4 FTE, use 96.4 × 21 working days as your denominator instead of 120 × 21. Our guide to FTE calculation walks through how to get that figure.

What Is a Good Absence Rate?

There is no universal target, but national data gives you a defensible reference point. The ONS put the UK sickness absence rate at 2.6% in 2022, the highest since 2004, with an estimated 185.6 million working days lost. The CIPD Health and Wellbeing at Work survey reported an average of 7.8 days lost per employee per year, the highest in over a decade.

Those two numbers use different units, so convert before comparing. A UK full-time employee has roughly 225 attendance days a year after weekends, public holidays and annual leave. 7.8 ÷ 225 = 3.47%, which is why organisational rates commonly sit above the national economy-wide figure.

Benchmarks vary sharply by sector, and for structural reasons rather than cultural ones:

• Public sector, healthcare and care work run higher. More physical roles, more exposure to illness, older workforces, and occupational sick pay schemes that make reporting absence viable rather than something people hide.
• Professional services and tech run lower. Desk-based work can often continue at partial capacity, and remote work absorbs mild illness that would once have been recorded as a sick day.
• Shift-based operations show more short spells, because a single missed shift is a full recorded absence.

Comparing your rate against a cross-industry average is close to meaningless. Compare against your own sector, and against your own trailing twelve months.

Absence Rate vs the Bradford Factor: Which Should You Use?

They measure different things, and swapping one for the other is a common reporting error.

	Absence rate	Bradford Factor
Formula	(Days lost ÷ Days available) × 100	S² × D (spells squared × days)
What it weights	Total volume of time lost	Frequency of separate absences
Best for	Benchmarking, capacity planning, cost	Spotting disruptive short-absence patterns
Level	Individual, team, company	Individual only

Run the same employee through both. Ten single-day absences and one ten-day absence produce an identical absence rate, because the volume is identical. Their Bradford Factor scores are 1,000 and 10 respectively, a hundredfold gap. Read our full guide to using the Bradford Factor fairly before you attach any trigger points to it, or run the numbers with the free Bradford Factor calculator.

Frequently Asked Questions

Should annual leave count in the absence rate?

No. Exclude approved annual leave. Absence rate is designed to measure unplanned lost time, and planned leave is already accounted for in your staffing model. Include sickness, unauthorised absence, and emergency dependant leave. State your inclusion rules in the policy so the number stays comparable year to year.

Do I use calendar days or working days?

Working days, on both sides of the calculation. If someone is signed off for two weeks, count 10 working days lost, not 14 calendar days, and use their scheduled working days in the denominator. Mixing the two is the most common reason an absence rate comes out far too low.

How often should I calculate the absence rate?

Monthly at company and team level, quarterly at individual level. Monthly reporting surfaces seasonal spikes and single-team problems while you can still act on them. Annual figures are only useful for board reporting and year-on-year benchmarking.

Can the absence rate exceed 100%?

No. The maximum is 100%, which would mean an employee missed every scheduled working day in the period. If your figure exceeds 100%, you have almost certainly counted calendar days as absence against a working-day denominator.

Getting the Data Right

The absence rate is only as good as your records. If absences are logged in a spreadsheet after the fact, half-days get rounded, short spells go unrecorded, and your denominator drifts as people join and leave mid-period.

Leave Balance records every absence with dates, type and duration as it happens, so your days lost and days available both come from the same source. Flat $10/month, unlimited employees, 14-day free trial.