How to use the scheduled vs actual hours variance calculator
- Set a grace period in minutes if your policy has one. Late minutes are counted after it.
- Add one row per shift with a name, the scheduled start and end and the actual in and out times.
- For an overnight shift, enter the end time as the next morning, such as 22:00 to 06:00. The page treats an end before the start as the next day.
- Read the late minutes, minutes left early, minutes after the scheduled end and the net difference for each shift and in total.
Formula
Late = actual in - scheduled start - grace period, if positive
Left early = scheduled end - actual out, if positive
After the scheduled end = actual out - scheduled end, if positive
Net difference = actual minutes worked - scheduled minutes, so a negative value is under the schedule
The net difference counts the full actual span. Arriving early adds to it, and it can differ from late minus early minutes. Your policy decides what to pay or approve.
Three shifts in one day
Avery is scheduled 09:00 to 17:00 and works 09:12 to 17:05. That is 12 minutes late, 0 left early and 5 after the end, for a net of -7 minutes. Blake is scheduled 08:00 to 16:00 and works 07:55 to 15:40, so 0 late, 20 left early and a net of -15.
Casey has an overnight shift from 22:00 to 06:00 and works 22:05 to 06:20. That is 5 late, 20 after the end and a net of +15. The totals are 17 late minutes, 20 minutes left early, 25 minutes after the scheduled end and a net difference of -7 minutes, or -0.1167 hours.
Reading the variance
A net difference near zero can hide offsetting problems: a late start made up by a late finish. The separate columns show where the time went. A pattern of late minutes may point to the start time, while minutes after the end may show work that should be planned in the schedule.
To total hours across a pay period, use the timesheet calculator, and to see overtime, use the overtime calculator.
Policy and pay
Rules for rounding, grace periods, breaks and overtime vary by employer and by place, and they are not part of this page. The grace period is an input you set. Treat the page as a way to organize the numbers, and check pay rules with your employer or the authority that applies.
For averages over several weeks, see the average weekly hours calculator.
Assumptions and limits
- Times are on a 24 hour clock, and an end time before the start time is the next day.
- Breaks are not deducted. Enter times that already reflect them, or adjust the totals.
- The grace period applies only to late arrival.
- The page does not apply pay rules, rounding or overtime.
Frequently asked questions
How do I compare scheduled and actual hours?
Enter the scheduled times and the clock in and out times for each shift. The page shows the late, early and extra minutes and the net difference.
How are overnight shifts handled?
If the end is earlier than the start, the page treats it as the next day, so 22:00 to 06:00 is 8 hours.
What does the grace period do?
Only the minutes beyond the grace period count as late. For example, 12 minutes late with a 5 minute grace period counts as 7. The grace period does not change the net difference.
Why is net different from late minus early?
The net difference compares the whole actual span with the scheduled span, so arriving early or staying late counts in it too.