Rostered versus worked hours calculator
One row per person: the hours they were rostered and the hours they worked. The difference and the percentage come out for each person and for the team.
| Person | Rostered | Worked | Difference | Percent |
|---|---|---|---|---|
A worked example
A week for three people, with the hours typed as they appear on the timesheets.
| Person | Rostered | Worked | Difference | Percent |
|---|---|---|---|---|
| Priya | 30:00 | 31:40 | +1h 40m | +5.6% |
| Callum | 22:00 | 14:30 | -7h 30m | -34.1% |
| Mei | 35:00 | 35:05 | +0h 5m | +0.2% |
Mei’s five minutes are noise. Callum’s missing seven and a half hours are a conversation: a sick day, a swap, or a clock in that never happened.
How it is worked out
difference = worked − rostered, and percent = difference ÷ rostered × 100 to one decimal place, shown when something was rostered.
What this tool cannot tell you
- Which hours should be paid
- Why a difference happened
- Whether a pattern is a problem, or a busy week
Questions
Which differences are worth chasing?
The ones that repeat. A few minutes either side of a shift is normal. The same twenty minutes on the same day every week is a pattern, and worth a conversation.
Should staff be paid for rostered hours or worked hours?
That depends on the award, the agreement and your own policy on early starts and late finishes. This tool shows the difference; it does not decide which hours count.
Where do the worked hours come from?
Timesheets, clock in records or payroll. In Roster Flow they come from clock ins, and the reports show this comparison for any period.