Hours variance equals actual hours minus scheduled hours. A positive result means more time was recorded than planned; a negative result means less. Calculate the difference using the same employees, dates and definition of hours before deciding what caused it.
This review is useful for improving a schedule. It is not a reason to replace accurate actual records with planned hours. Keep your original schedule, approved changes and actual time records as separate versions.
Make the two totals comparable
Decide whether you are comparing elapsed time, paid hours or productive coverage hours. An eight-hour presence with a 30-minute unpaid break is 7.5 paid hours. Comparing eight scheduled elapsed hours with 7.5 actual paid hours creates a half-hour difference that comes from definitions, not performance.
Use the same reporting window and a consistent way to allocate overnight shifts. Where you need to split a shift across dates or workweeks, do that consistently in both datasets. Check the overnight hours guide and break subtraction example before totaling the week.
Calculate a weekly variance
| Employee | Scheduled | Actual | Actual minus scheduled |
|---|---|---|---|
| Ana | 40.0 | 41.5 | +1.5 |
| Ben | 32.0 | 30.0 | −2.0 |
| Chloe | 24.0 | 26.5 | +2.5 |
| Total | 96.0 | 98.0 | +2.0 |
The team recorded two more hours than planned. Relative to 96 scheduled hours, the difference is 2 ÷ 96 × 100 = 2.08%. Calculate this percentage from the totals rather than averaging each employee’s percentage.
The small team total hides opposing differences: Ben is two hours below plan while Ana and Chloe are collectively four hours above it. Review the rows before concluding that the schedule was close enough.
Use simple Excel formulas
Put employee names in column A, scheduled decimal hours in B and actual decimal hours in C. In D2, enter =C2-B2. In E2, enter =IF(B2=0,"",D2/B2) and format E as Percentage. A blank percentage means there is no nonzero scheduled baseline; investigate the row rather than treating it as a zero-percent difference.
For the three-person example in rows 2–4, use =SUM(B2:B4), =SUM(C2:C4) and =SUM(D2:D4) for the totals. Keep decimal hours consistent: 7 hours 30 minutes is 7.5, not 7.30. The decimal hours conversion guide explains the distinction.
If your source contains Excel time values instead, remember that time is stored as a fraction of a day. Convert a duration to decimal hours before mixing it with numeric totals. See how to display Excel totals above 24 hours if a weekly sum appears to wrap around.
Separate an hours gap from a cost gap
If every hour in the example cost a flat $20 with no premiums, the two extra hours would add $40. Real assignments may involve different people, rates and premiums, so that shortcut may not explain the actual wage difference.
Two changes can even cancel out in hours while increasing cost. Removing two hours from a lower-rate assignment and adding two hours to a higher-rate assignment preserves total hours but changes the wage estimate. Reprice the actual assignments before labeling the whole difference an “hours overrun.”
For a sales-based view, use the restaurant labor cost percentage example. It distinguishes a wage change from a sales shortfall, which can raise the percentage even if hours do not move.
Use reason codes that lead to an action
- Demand changed: review the workload forecast for that day and time.
- Approved roster change: compare against the amended schedule as well as the original baseline.
- Missing or incorrect record: investigate and correct through your normal time-record process.
- Training or handover: determine whether the next schedule needs an explicit allowance.
- Unfilled assignment: check what work or coverage was missed, not just the hours saved.
Keep an “unexplained” category until you have evidence. Do not automatically interpret every late clock-out as low productivity or every negative variance as a saving. Check timesheet control totals before drawing operational conclusions from an incomplete export.
A repeatable weekly review
- Freeze the original scheduled-hours baseline.
- Record approved changes in a separate version.
- Collect and reconcile the actual time records.
- Calculate differences by employee, day and role.
- Investigate the largest unexplained changes.
- Record one planning change to test next week.
For proposed changes before the shift happens, follow the shift swap checklist. For the initial baseline, use the weekly employee schedule layout.
Intious Shift Planner Pro brings manual shift planning and planned-versus-actual cost review into Excel. It is not a time clock or payroll system; retain accurate source records and review the workbook’s inputs.
Reference: Microsoft’s guide to calculating time differences explains Excel’s time calculations. The variance table and review process above are original worked examples.