Absence Rate Calculator
From absent days and scheduled work days, work out the absence rate as a percentage for an employee or a team.
Input Data
Results
At a glance:Absence rate = absent days / scheduled work days x 100%. 'Absent days' are unscheduled absences (sick, personal, unauthorised, per company definition); 'scheduled work days' are roster-required days (usually excluding public holidays and approved leave). Example: 200 scheduled, 10 absent gives 5.00%. It is a key HR indicator of attendance stability and workforce availability. WARNING: It does not explain causes; definitions vary across firms; sick leave and holidays are protected by Hong Kong's Employment Ordinance, so management must be lawful and non-discriminatory.
Formula
Absence rate = absent days / scheduled work days × 100%.
$$\text{Absence \%} = \dfrac{\text{Absent Days}}{\text{Scheduled Days}} \times 100\%$$How to Use
- Enter the employee's or team's absent days in the period.
- Enter the total scheduled work days in the same period.
- View the absence rate as a percentage.
Example reference table: with 200 scheduled work days (about one quarter), the absence rate for various numbers of absent days
| Absent days | Scheduled days | Absence rate | General reading |
|---|---|---|---|
| 2 days | 200 days | 1.00% | Very low; stable attendance |
| 5 days | 200 days | 2.50% | Low; within normal range |
| 10 days | 200 days | 5.00% | Moderate; watch the trend |
| 20 days | 200 days | 10.00% | High; investigate the cause |
| 30 days | 200 days | 15.00% | Very high; address promptly |
Based on 200 scheduled days: absence rate = absent days / 200 x 100%. Each extra 2 absent days raises the rate by 1 percentage point. The readings above are for general reference only — high absence may be legitimate (e.g. flu season) and must be read in context; do not draw conclusions from the number alone.
Case Studies
Individual quarterly review: 60 scheduled days, 6 absent
An employee was scheduled for 60 days in a quarter but was actually absent 6 days (including several sick days and one personal day). Absence rate = 6 / 60 x 100% = 10.00%.
On its own, '6 absent days' may seem minor, but as a 10% rate it means one-tenth of their work days were missed, which merits follow-up. Read it carefully, though: if those 6 days clustered in a flu peak with valid medical certificates, that is lawful sick leave and the focus should be support (workload, health), not penalty. This is exactly what the absence rate is for — placing absolute days against the 'scheduled' baseline so managers see the relative weight, notice it early, and then read it together with causes.
Team comparison: 20 staff, 22 scheduled days each, 35 absent in total
A department has 20 staff this month, each scheduled for 22 days, so total scheduled days = 20 x 22 = 440; total absent days for the month = 35. Team absence rate = 35 / 440 x 100% ≈ 7.95%; average absence per person = 35 / 20 = 1.75 days.
When calculating a team rate, the key is to use 'total scheduled days of all members' (headcount x scheduled days per person) as the denominator, not one person's days, or you severely overestimate. A 7.95% team rate can be compared with the same period last year or industry levels to judge if it is high; a sudden spike in a given month warrants checking for a collective health event, morale or process issues. Tracking the 'trend' is usually more valuable than a single number.
FAQ
What absence rate is high?
No universal standard — it depends on industry, season and definition. Single-digit rates (e.g. 2-4%) are generally normal; sustained higher levels deserve attention. But read context: flu season spikes are normalfluctuation; chronically high rates may signal stress, morale or occupational-health issues. Track trends versus your own history and peers.
Do annual leave and statutory holidays count as absence?
Usually not. The absence rate measures unplanned, operation-disrupting absences (sick, personal, unauthorised). Paid annual leave, statutory holidays, maternity and paternity leave are legal rights and pre-arranged, not absence. Define 'absent days' and 'scheduled days' consistently — scheduled days should already exclude public holidays and approved leave.
How does Hong Kong sick leave affect the rate?
It counts, but management must comply with the law. The Employment Ordinance protects employees' sick-leave rights — eligible employees accrue paid sick leave and receive sickness allowance with a valid medical certificate. These are statutory rights; employers must not discriminate or penalise employees for taking lawful sick leave. Use the rate to understand staffing and team health, not to target individuals.
How do I calculate a team's absence rate?
Use summed figures: team absence rate = total absent days of all members / total scheduled days of all members x 100%, where total scheduled days = headcount x scheduled days per person (sum individually if they differ). Example: 20 staff x 22 days = 440 scheduled; 35 absent days gives 35 / 440 = 7.95%. The team rate reflects overall labour loss; pair it with individual outliers for case follow-up.
How should I respond to a high absence rate?
First understand the cause, not rush to penalise. Separate certified sick leave, personal leave and unauthorised absence; look for patterns (Mondays, before/after holidays, specific teams). Address root causes — workload, flexibility, health support, or safety. Ensure any measure complies with the Employment Ordinance and is non-discriminatory. The rate's value is as an early signal, not a punishment tool.
Related Tools
References
Content review: Calculatorism Finance Team. Results are for reference only; please refer to the relevant authorities for the official figures.