Absenteeism rate calculator

Find the share of scheduled work time lost to unplanned absences.

In shortAbsenteeism rate = days lost to unplanned absence ÷ (employees × workdays in the period) × 100. You can use hours instead of days if your team works different shift lengths.

Who uses itSupervisors, HR and operations leads
WhenMonthly, or after an attendance policy change
You needUnplanned absence days or hours and scheduled time
ResultAbsence as a share of scheduled time

Enter your figures

How the math works

Total scheduled time = employees × scheduled days (or hours) per employee.

Absenteeism rate = unplanned absence ÷ total scheduled time × 100.

See it with numbers

A call center has 25 agents and 21 workdays in March. They lost 18 days to unplanned absence. Total scheduled days are 525, so the absenteeism rate is 3.43%, or 0.72 days per agent.

When to check your absenteeism rate

Use it to compare teams, months or locations, or to see whether a new attendance policy is working.

Count only unplanned absences, such as sick days and no-shows. Approved vacation and protected leave are usually excluded, so the rate shows disruption rather than planned time off.

A second example

A warehouse tracks absence in hours because many call-outs are partial shifts. Its 60 associates were scheduled 160 hours each in October, 9,600 hours in total, and lost 230 hours to unplanned absence. The absenteeism rate is 2.40%, or 3.83 hours per associate. Counting each partial call-out as a full lost day would have pushed the rate higher than the time actually missed.

Making sense of the absenteeism rate number

The rate is the share of scheduled time lost, so 2% means about 1 hour in every 50 scheduled was missed. It is misleading if absences and scheduled time use different units or periods, or if approved vacation and protected leave slip into the absence figure. Average absence per employee hides concentration, because a few long absences give the same figure as many short ones.

Where this usually goes wrong

Treating a late arrival of 3 hours as a full absence day. Use hours when partial absences are common.
Counting approved leave under FMLA or state law as unplanned absence. Keep protected leave out of attendance scoring.
Comparing a 25-person team with a 3-person team by raw days lost. Always compare the rate, not the count.

Tailor it to how you work

Call centersMeasure by interval and weekday, since Monday and post-holiday absence can wreck service levels on specific days.

Construction crewsTrack absence by site, because weather and travel distance affect some sites far more than others.

From the fieldLook at absence by day of the week. A spike on Mondays or Fridays points to a different cause than absence spread evenly.

Questions about the absenteeism rate

Should vacation count?

Usually not. Measure unplanned absence separately from planned time off.

Days or hours?

Hours are more accurate when shift lengths differ.

How do I get the data?

From time and attendance records, which show scheduled versus worked time.

What about protected leave?

Do not use protected leave against employees. Get advice on how to report it.

How do I count a half-day absence?

Switch the unit to hours and enter the missed hours, such as 4 for a missed afternoon, with scheduled hours per employee. In days mode you would have to enter 0.5, which only works if every workday is the same length.

Should employees on long approved leave stay in the headcount?

Leave them out for that period. If you keep their scheduled days in the total but exclude their protected leave from absence, the rate looks lower than it really is for the people who are actually working.

Keep going

More for the same job

Useful next steps

Get real hours into the math

EZTime tags hours by job, client and role and shows real-time labor costing on the schedule, so estimates can be checked against actual hours. A 14-day trial needs no credit card.

Book a demo Start a trial

General information and an estimate only. It is not legal, payroll, tax or financial advice. Rules vary by state and city. Check important results with a qualified professional.