On-time rate over a period
Punctuality and attendance measure different failures. Merging them hides both. Somebody who never misses a day and never arrives on time scores perfectly on attendance. Punctuality is where that shows up.
Fill in every field to see the result.
How to use it
Step 1
Count the arrivals recorded in the period. Leave days do not belong there.
Step 2
Count how many of those arrivals were late after grace was applied.
Step 3
Add the total late minutes if you have them, for the second figure.
Step 4
The average is taken over the late days only. Eleven minutes when late is useful; the same minutes spread across a whole month is not.
Step 5
Make sure every day was recorded first. A day with no punch counts as neither on time nor late, so gaps make the rate look better than it is.
Step 6
Confirm each person's shift start before you act on the figure. Late minutes counted against the wrong shift aren't real lateness.
Questions people ask
How is on-time rate different from attendance rate?
Attendance counts whether someone came in. On-time rate counts whether they arrived by their start time. A person can score 100% on the first and badly on the second.
Should days off count in the denominator?
No. Count only the days an arrival was expected. Leaving rest days and approved leave in the total inflates the percentage and makes periods impossible to compare.
Why average late minutes over the late days only?
Because that answers the question managers actually ask: when this person is late, how late? Dividing by the whole month turns a real pattern into a small, comfortable number.