An hours-based absenteeism rate measures the share of scheduled working time lost to a defined category of absence. Divide qualifying absent hours by scheduled hours for the same people and dates, then express the result as a percentage. The definition of qualifying absence must be stated; sickness-only and all-unplanned-absence measures answer different questions.
Choose a clear numerator and denominator
Hours-based absence rate = qualifying absent hours ÷ scheduled working hours × 100.
Use scheduled hours before the qualifying absence occurred. If a person was scheduled for eight hours and missed all eight, retain eight in the denominator and add eight to the numerator. Removing those hours from the schedule after the absence would make the denominator shrink and distort the measure.
Decide in advance how approved leave, public holidays, training, lateness and early departures are classified. For example, a sickness-only measure can exclude planned vacation from both the opportunity-to-work base and the sickness numerator. It should not exclude an actual sick shift from the base after the fact. Preserve a dated schedule snapshot and publish the rule used.
Calculate full and partial shifts
| Event | Scheduled hours | Qualifying missed hours |
|---|---|---|
| Full shift missed | 8 | 8 |
| Two hours late | 8 | 2 |
| Four hours missed on a long shift | 10 | 4 |
| Total for these records | 26 | 14 |
These records illustrate how to add hours, not a complete team rate. Suppose the full team's scheduled time is 1,600 hours and its qualifying absent time is 64 hours, including these events. The period rate is 64 ÷ 1,600 × 100 = 4%. Subtract unpaid break time consistently from both scheduled working time and the corresponding missed interval when that is how the schedule is defined.
Hours are usually more comparable than days when employees work different shift lengths. Missing one four-hour shift and one twelve-hour shift is two missed shifts but sixteen missed hours. Converting both into a standard eight-hour day is a separate reporting convention and should be labeled.
Combine teams using the underlying hours
Team A records 40 absent hours out of 800 scheduled hours, or 5%. Team B records 20 out of 200, or 10%. Combined, the rate is 60 ÷ 1,000 = 6%. The simple average of 5% and 10% is 7.5%, which overweights the smaller team.
The same rule applies across months: add the numerator hours and denominator hours first. A rolling twelve-month rate needs twelve months of compatible records, not a recent monthly percentage multiplied by twelve. Zero scheduled hours should produce “not applicable,” not zero percent, because no opportunity-to-work base exists.
Keep absence and coverage separate
An absent eight-hour shift remains eight absent hours even if a colleague covers it. Replacement labor changes the coverage outcome; it does not erase the original absence. Track the original absence rate, uncovered position-hours and replacement hours separately.
For example, an eight-hour absence covered for six hours leaves two uncovered position-hours. If the six replacement hours are overtime, classify them in the overtime record as well. Do not subtract replacement hours from absent hours and call the result an absence rate. Use the coverage calculator to inspect when the replacement is actually present, since a matching daily total can still leave an interval uncovered.
Do not confuse this with the BLS absence rate
The BLS CPS absence table defines an absence rate based on workers with qualifying absences among full-time wage and salary workers. Its lost-worktime measure is separate. Our scheduled-hours ratio is an internal operational measure and should not be directly compared with a people-based statistic.
An employee with several short absences can contribute many events but still be one person. For that reason, event frequency, percentage of people affected and hours lost belong in separate columns. A chart should identify which of these it displays.
Interpret the number with context
Show the reporting period, scope, scheduled hours, missed hours and inclusion policy alongside the rate. Correct duplicate records and overlapping absence intervals before adding hours. A missed interval cannot be counted twice simply because two reason codes were recorded.
Use aggregated results to plan resilient coverage and investigate scheduling patterns. The percentage alone does not establish why someone was absent, whether an absence was avoidable or whether an employment action is appropriate. Keep individual circumstances and applicable leave requirements outside this arithmetic shortcut.
Related calculators and guides
- Staffing Shrinkage and Productive Capacity Calculator
- Plan Break Coverage Without Double-Counting Staff
- Why Enough Staff Hours Can Still Leave Coverage Gaps
Explore more in Workforce Planning Calculators and Guides.