The formula
Absenteeism rate (%) = unplanned absent days ÷ total scheduled working days × 100. Scheduled working days are the days employees were rostered to work, so weekly offs and holidays are excluded from the denominator. Unplanned absences are days an employee was rostered and did not turn up without prior approval; approved leave is planned and excluded from the numerator. Some companies also count uninformed late arrivals beyond a threshold as partial absence.
The same ratio can be computed in hours for shift workers where partial-day absence matters. Compute it per employee, per site or department, and for the whole organisation, and always state the period (month, quarter). Use the absenteeism rate calculator to check your inputs.
Planned vs unplanned absence and the Bradford factor
Approved earned leave, casual leave taken with notice, maternity leave and weekly offs are planned: they are known when the roster is built and can be covered. Absenteeism is about the unplanned residue that disrupts operations: no-shows, uninformed sick days, walk-outs. Mixing the two hides the operational problem inside the leave budget.
Frequency matters as much as volume. Ten single days scattered across a year are far more disruptive than one ten-day absence. The Bradford factor captures this: B = S² × D, where S is the number of separate absence spells and D the total days. An employee with 10 spells of 1 day scores 10² × 10 = 1,000; one with a single 10-day spell scores 1 × 10 = 10. Use it as a trigger for conversation, not as a disciplinary formula.
- Count only rostered days in the denominator.
- Exclude approved leave, weekly offs and holidays.
- Track spells separately from days to see frequency.
- Segment by site, shift and day of week to find patterns (Monday nights, post-payday).
Benchmarks, causes and reduction
Published benchmarks vary widely by industry and country and should be treated with caution; your own trend matters more than an external number. In Indian security and housekeeping operations the rate typically spikes around festivals, harvest season for workers with rural homes, and the days after salary is paid. Rostering that ignores these patterns manufactures no-shows.
Reduction levers are practical: publish rosters early, pay on time, make leave easy to apply for so absence becomes planned, use open shifts to cover fast, and follow up every uninformed absence the same day. Our guide on the absenteeism rate formula and reduction goes deeper.
In a 30-day month, 50 guards are rostered for 26 duty days each: 1,300 scheduled days. Approved leave accounts for 60 days and is excluded. Uninformed absences total 52 days. Absenteeism rate = 52 ÷ 1,300 × 100 = 4.0%. Those 52 days were covered by 30 reliever days and 22 doubles at overtime, costing the agency roughly 22 × 12 hours at double rate above plan. Segmenting shows 18 of the 52 fell on the two days after salary credit.
Attend Mitra's analytics compare rostered shifts with actual punches, so absent days are counted against the roster, approved leave is separated automatically, and rates can be viewed by site, department, shift and period. Reports export to CSV, PDF or XLSX for client reviews and management meetings.