How to Calculate Absenteeism Rate

To calculate absenteeism rate, divide the hours of unplanned absence by the hours scheduled for the same period, then multiply by 100. Convert hours and minutes to minutes or decimal hours first: 18:20 missed out of 162:00 scheduled is 1,100 ÷ 9,720 minutes, an absenteeism rate of 11.32%.

What is absenteeism rate?

Absenteeism rate is the share of scheduled work time that was lost to absence. It answers one question: of all the hours people were supposed to be at work, what percentage did they miss?

Absenteeism rate = absence hours ÷ scheduled hours × 100

The formula is simple. The two things that make the answer wrong are deciding what goes into each total, and doing a division on hours and minutes as if they were ordinary decimals. This guide covers both.

How do I calculate absenteeism rate step by step?

  1. Choose the period and the group. One week, month or quarter; one person, team or site. Both totals must cover exactly the same people and the same dates.
  2. Decide what counts as an absence. Usually unplanned time away: sick calls, no-shows, late arrivals and early departures. Usually not approved vacation or holidays. More on this below.
  3. Total the scheduled hours in H:MM. Add every scheduled shift, carrying each 60 minutes into an hour. Our guide to adding hours and minutes shows the carrying.
  4. Total the absence hours in H:MM. Add every counted absence the same way.
  5. Convert both totals to minutes. Hours × 60, plus the minutes. Decimal hours work too.
  6. Divide absence by scheduled.
  7. Multiply by 100. That is the rate. Subtract it from 100 for the attendance rate.

Worked example: a five-person team for one week

A shop manager wants last week’s absenteeism rate. The schedule and the time cards show:

PersonScheduledMissedWhat happened
Ana40:008:00Called in sick one day
Ben37:302:45Left early one afternoon
Cara40:000:00Worked every shift
Dev24:306:15Missed one shift
Eli20:001:20Arrived late one morning
Team162:0018:20 

Scheduled hours. The hours are 40 + 37 + 40 + 24 + 20 = 161. The minutes are 30 + 30 = 60, which is one more hour. Total: 162:00.

Absence hours. The hours are 8 + 2 + 6 + 1 = 17. The minutes are 45 + 15 + 20 = 80, which is 1:20. Total: 18:20.

To minutes. 18:20 is 18 × 60 + 20 = 1,100 minutes. 162:00 is 162 × 60 = 9,720 minutes.

The rate. 1,100 ÷ 9,720 = 0.1132, and 0.1132 × 100 = 11.32%.

The decimal route agrees: 18:20 is 18.3333 hours, and 18.3333 ÷ 162 = 0.1132. The attendance rate is the rest of the 100%: 100 − 11.32 = 88.68%.

Why can’t I just type 18:20 as 18.20?

Because minutes are sixtieths of an hour, not hundredths. 18:20 is 18.33 hours; 18.20 hours is 18:12. On the team total the slip is small, but on individual rates, where both numbers have minutes, it is easy to see:

Whose rateCorrect (in minutes)Typed as decimals
Team: 18:20 of 162:001,100 ÷ 9,720 = 11.32%18.20 ÷ 162 = 11.23%
Ben: 2:45 of 37:30165 ÷ 2,250 = 7.33%2.45 ÷ 37.30 = 6.57%
Dev: 6:15 of 24:30375 ÷ 1,470 = 25.51%6.15 ÷ 24.30 = 25.31%

Typing H:MM as a decimal always understates the minutes, and it does so by a different amount on each line, so the errors do not cancel. Convert first; the full method is in our hours to decimal guide.

How do I calculate the rate for each person?

Use the same formula with one person’s numbers: their absence hours over their own scheduled hours.

PersonMissed ÷ scheduledIn minutesRate
Ana8:00 ÷ 40:00480 ÷ 2,40020.00%
Ben2:45 ÷ 37:30165 ÷ 2,2507.33%
Cara0:00 ÷ 40:000 ÷ 2,4000.00%
Dev6:15 ÷ 24:30375 ÷ 1,47025.51%
Eli1:20 ÷ 20:0080 ÷ 1,2006.67%

Dev missed fewer hours than Ana but has the higher rate, because the same kind of absence, one shift, is a bigger share of a part-time schedule. That is the rate doing its job: it measures absence relative to what was scheduled.

Do not average these percentages to get the team rate. (20.00 + 7.33 + 0.00 + 25.51 + 6.67) ÷ 5 = 11.90%, but the team rate is 11.32%. Averaging treats Eli’s 20 scheduled hours as if they carried the same weight as Ana’s 40. The team rate always comes from the two totals: all absence hours over all scheduled hours.

Should I count hours or days?

Some workplaces count absence in days: days absent ÷ days scheduled. That works when everyone has the same shift length and only full-day absences are tracked. It breaks down as soon as shifts differ or people miss part of a day. The team above was scheduled for 5 + 5 + 5 + 4 + 4 = 23 working days:

MethodThe mathRate
Days, full-day absences only2 ÷ 238.70%
Days, every incident as a full day4 ÷ 2317.39%
Hours actually missed18:20 ÷ 162:0011.32%

The first row ignores Ben’s early exit and Eli’s late arrival entirely. The second charges Eli a whole day for 1:20. The hours method counts what was really lost, and it weighs a missed 6:15 shift as 6:15 rather than as the same “one day” as a missed 8:00 shift. If your time cards record hours and minutes, use them.

What counts as an absence, and what gets left out?

There is no single official definition, so the rate is only comparable from one period to the next if the same rules are applied every time. A common approach:

Whatever you leave out of the absence total should also come out of the scheduled total. If someone has an approved vacation day, that day is neither an absence nor a scheduled day; it is simply not part of the calculation. Leaving it in the denominator makes the rate look better than it is; putting it in the numerator makes it look far worse.

Some absences are protected by law or by contract, such as certain family, medical and sick leave. Whether those belong in a rate used for attendance decisions is a legal question, not an arithmetic one. If the number will be used for more than planning, check with HR or a qualified adviser about which absences can be counted.

How do I calculate one person’s rate for a month?

Priya works 8:00 a day, Monday to Friday. November 2026 has 21 weekdays, and her employer closes for one paid holiday, so she is scheduled for 20 days:

Scheduled: 20 × 8:00 = 160:00

During the month she takes one sick day (8:00), arrives 0:35 late once and leaves 2:10 early once:

Absence: 8:00 + 0:35 + 2:10 = 10:45

10:45 is 645 minutes and 160:00 is 9,600 minutes. 645 ÷ 9,600 = 0.0672, so her rate for the month is 6.72%. Here is how the holiday changes the answer if it is handled differently:

How the holiday is treatedThe mathRate
Left out of both totals (consistent)10:45 ÷ 160:006.72%
Left in the scheduled hours only10:45 ÷ 168:006.40%
Counted as scheduled and as an absence18:45 ÷ 168:0011.16%

Same person, same month, three different numbers. None of the arithmetic is wrong in the second and third rows; the definitions are. For help building the scheduled-hours side, see how many work hours are in a month.

What does each amount of missed time work out to?

For one person on a 40:00 week or a 160:00 month:

Time missedOf a 40:00 weekOf a 160:00 month
0:301.25%0.31%
1:002.50%0.63%
1:303.75%0.94%
2:005.00%1.25%
4:0010.00%2.50%
8:0020.00%5.00%
16:0040.00%10.00%
24:0060.00%15.00%

One sick day is 20% of a week but 5% of a month. Short periods swing wildly on a single absence, which is why a weekly rate for one person says very little and a monthly or quarterly rate for a team says more.

How do I turn a target rate back into hours?

Multiply the scheduled hours by the target percentage. If the shop aims for 2.5% on a 162:00 week:

162 × 0.025 = 4.05 hours = 4:03

The 0.05 of an hour is 0.05 × 60 = 3 minutes, so the target allows 4:03 of absence, not 4:05. Last week’s 18:20 was 18:20 − 4:03 = 14:17 over it. Reading a decimal result as a clock time is the same mistake as typing 18:20 as 18.20, made in the other direction.

What are the missed hours worth in wages?

Multiply each person’s missed time, in decimal hours, by their hourly rate:

PersonMissedDecimalHourly rateWage value
Ana8:008.00$22.00$176.00
Ben2:452.75$20.00$55.00
Dev6:156.25$18.00$112.50
Eli1:201.3333$17.25$23.00
Total18:2018.3333 $366.50

Eli’s line is where the decimal slip bites: 1.20 × $17.25 = $20.70, which is $2.30 short of the real $23.00. Treat the $366.50 as the wage value of the hours, not the full cost of the absences. If the time was unpaid, no wages went out; if someone covered at overtime rates, the cost was higher. The pay arithmetic is in how to calculate pay from hours worked.

Does the rate show how often people are absent?

No. The rate measures how much time was lost, not how it was spread out. One person out for a full week and another out on five separate Mondays have both missed 40:00, and their rates are identical, but the five separate absences are usually harder to plan around.

Some organizations track that with the Bradford Factor, which weights frequency:

Bradford Factor = (number of separate absences)² × total days absent

One five-day absence scores 1 × 1 × 5 = 5. Five one-day absences score 5 × 5 × 5 = 125. It is a blunt tool and can penalize people with recurring health conditions, so it is best used as a prompt for a conversation rather than a verdict. For most scheduling and budgeting purposes, the hours-based rate plus a simple count of incidents is enough.

What mistakes skew an absenteeism rate?

Total the missed time without converting anything

Hours: Time Card Calculator adds and subtracts hours and minutes in H:MM, so 8:00 + 2:45 + 6:15 + 1:20 comes back as 18:20, and one tap shows it as decimal hours, ready to divide. It saves your history, exports to CSV or PDF, is free, works offline, has no ads and needs no account.

Download Hours free

Frequently asked questions

What is the formula for absenteeism rate?

Absenteeism rate = hours of unplanned absence ÷ hours scheduled × 100, for the same people and the same period. 18:20 missed out of 162:00 scheduled is 1,100 ÷ 9,720 minutes = 11.32%.

Should I calculate absenteeism in hours or days?

Hours are more accurate whenever shifts differ in length or people arrive late and leave early. In the example week, counting only full days gives 8.70%, counting every incident as a full day gives 17.39%, and counting actual hours gives 11.32%. Days are fine when everyone works the same shift and only full-day absences are tracked.

Do vacation days and holidays count as absenteeism?

Usually not. Most definitions count only unplanned absences such as sick calls, no-shows, late arrivals and early departures, and leave out approved vacation, company holidays and other scheduled leave. There is no single standard, so write your own definition down and apply it the same way every period.

What is a good absenteeism rate?

There is no universal figure. Rates vary by industry, season, shift pattern and by what each employer counts. The most useful comparison is your own rate over time, measured with the same definition, alongside any target your organization has set.

How do I calculate the absenteeism rate for one employee?

Divide that person’s unplanned absence hours by their own scheduled hours and multiply by 100. 10:45 missed out of 160:00 scheduled in a month is 645 ÷ 9,600 minutes = 6.72%.

What is the difference between absenteeism rate and attendance rate?

They are two halves of the same 100%. Attendance rate = 100 − absenteeism rate, so an 11.32% absenteeism rate is an 88.68% attendance rate.

This guide covers the arithmetic of absenteeism rate. Which absences an employer may count, and how attendance records may be used, depend on the employer, the state, any contract and laws that protect certain kinds of leave. It is general United States information, not legal or tax advice — check your own policy and ask your HR or payroll office or a qualified adviser about your specific case.