Try Updoot Free

When spreadsheets get messy, try Updoot

← Back to BlogHow smart managers are never chasing timesheets again.Never chase timesheetsShow me

Scheduled vs. Actual Hours: How to Track and Close the Gap

Scheduled vs. Actual Hours: How to Track and Close the Gap
Share LinkedIn Facebook

Quick Answer

Scheduled hours are the hours you planned; actual hours are the hours employees really worked, based on time clock records. To compare them, subtract scheduled hours from actual hours for each shift, employee and week. A gap of a few minutes is normal, but regular gaps point to scheduling, workflow or attendance problems. Always pay non-exempt employees for the hours they actually worked, not the hours on the schedule.

The schedule says 40 hours. The time clock says 44. Payroll says overtime. Somewhere between the plan and the punch, four hours appeared, and nobody quite knows where they came from.

Comparing scheduled hours to actual hours is one of the simplest ways to find hidden labor costs, spot overtime before it happens and build schedules that match how work really gets done. This guide shows how to calculate the gap, what causes it, what the law requires and how to close it.

Note: This is general information, not legal advice. Wage and hour rules vary by state and city, so check the rules where your team works.

Scheduled Hours vs. Actual Hours

Scheduled hoursActual hours
What it isThe hours you planned for each shiftThe hours employees actually worked
Where it comes fromYour scheduleTime clock punches or timesheets
Used forPlanning coverage and labor budgetPaying employees and measuring real labor cost
Pay is based onNot the scheduleActual hours worked, for non-exempt employees

The schedule is a plan. Time records are the facts. When the two disagree, the time records win for pay purposes, which is why the gap matters.

How to Calculate the Gap

Hours variance = Actual hours − Scheduled hours
Variance % = (Actual hours − Scheduled hours) ÷ Scheduled hours × 100

A positive number means people worked more than planned. A negative number means less. Look at it three ways: by shift, by employee and by week.

Example: One Week for One Employee

DayScheduledActualVariance
Monday8.08.5+0.5
Tuesday8.08.00.0
Wednesday8.09.25+1.25
Thursday8.08.75+0.75
Friday8.09.5+1.5
Total40.044.0+4.0 (10%)

No single day looks alarming, but together they add four hours of overtime. For a non-exempt employee earning $20 an hour, that's four hours at $30, or $120 more than planned for one person in one week, before employer payroll taxes.

Example: A Team View

EmployeeScheduledActualVariancePattern
Alex4044+4Runs late at close
Jordan3231−1Left early Friday
Sam4040.5+0.5Normal
Taylor2428+4Covered a call-out
Team136143.5+7.5 (5.5%)

The team view shows where to look. Alex's gap is a pattern worth asking about. Taylor's was a one-time coverage need.

What Is a Normal Gap?

There's no official standard. A few minutes per shift is normal and expected, since people don't clock in and out to the exact second. What matters is the pattern:

Track your own variance for a few months to learn what's typical for your business, then watch for changes.

Common Causes of Hours Running Over

CauseWhat it looks likeFix
Closing tasks take longer than plannedEvening shifts always run 30 to 60 minutes longSchedule closing time into the shift
Call-outs and coverageOthers work extra shifts or stay lateBuild a backup list and cross-train
Busy periods not staffedOvertime on the same days each weekSchedule to demand
Early clock-insPunches 10 to 20 minutes before shift startSet and communicate a clock-in window
Workflow bottlenecksJobs take longer than estimatedFix the process, not just the schedule
Shift handoffsOutgoing staff stay to brief the next shiftUse a written handoff and overlap time

Common Causes of Hours Running Under

Be careful with that last one. A missed punch doesn't mean the time wasn't worked. Correct it with an approved edit before paying. See the timesheet edit form.

What the Law Requires

Pay for Actual Hours Worked

Under the Fair Labor Standards Act, non-exempt employees must be paid for all hours actually worked. The Department of Labor explains that work not requested but "suffered or permitted" is work time that must be paid. So if an employee stays 30 minutes past their scheduled shift to finish a task, that time must be paid, even if it wasn't approved. You can address unapproved overtime through your policies, but you can't refuse to pay for it.

Overtime Is Based on Actual Hours

Federal overtime of at least time and a half applies to hours actually worked over 40 in a workweek for non-exempt employees, not scheduled hours. Some states also have daily overtime rules. See overtime laws by state.

Early and Late Punches and Rounding

Federal regulations allow employers to disregard early or late punches when employees clock in early or stay late without doing any work, and allow rounding to the nearest 5 minutes, tenth or quarter of an hour, as long as rounding doesn't, over time, result in employees being underpaid for time they actually worked. If someone clocks in early and starts working, that time counts. See the time clock rounding guide.

State and Local Scheduling Laws

Some states and cities add rules about the schedule itself. For example:

If you operate in one of these places, your scheduled-vs-actual comparison isn't just a cost tool. It also helps you document schedule changes and any extra pay owed.

How to Track Scheduled vs. Actual Hours

  1. Publish a clear schedule with exact start and end times for every shift.
  2. Use a reliable time clock so actual hours come from punches, not memory. See how to track employee hours.
  3. Compare daily for problem shifts and weekly for overtime risk.
  4. Flag variances over a set threshold, such as 15 minutes per shift or two hours per week.
  5. Ask about patterns, not single days.
  6. Adjust the schedule based on what you learn.
  7. Review monthly to see whether the gap is shrinking.

A Simple Weekly Tracking Template

EmployeeScheduledActualVarianceOvertime hrsNotes
[Name]
[Name]
[Name]
Total

Add a notes column and fill it in. "Covered call-out," "truck arrived late" or "inventory night" turns numbers into decisions. You can build this in a spreadsheet using our timesheet template.

How to Close the Gap

Fix the Schedule

Fix the Process

Fix the Conversation

When one person's hours run over or under regularly, ask before assuming:

"I noticed your shifts have been running about 45 minutes long most nights. What's happening at close? I want to make sure the schedule matches the work, and that you're getting paid for all of it."

That last line matters. It makes clear that the goal is an accurate schedule, not unpaid work.

Common Mistakes

Why This Matters for Labor Costs

The gap between scheduled and actual hours is often the biggest reason labor costs come in over budget. Closing even part of it can make a real difference. See labor cost percentage: how to calculate and control it for the bigger picture.

Setting a Clock-In and Overtime Policy

A short written policy reduces surprises on both sides. It should cover:

That last point protects you as much as your employees. A policy can require approval for overtime and set consequences for not following the rules, but it can't make worked time unpaid. See how to create an HR policy for a format.

Worked Example: Fixing a Closing Shift

A small cafe schedules its two closers from 3:00 PM to 9:00 PM. Every week, both employees clock out around 9:45 PM. That's 45 minutes over per person per shift, or about 7.5 extra hours a week across both closers on five closing shifts.

Instead of telling the closers to hurry, the manager asks what's happening. The answer: the cafe closes at 9:00, but cleaning, counting the drawer and taking out trash can't start until the last customers leave. The fix isn't speed; it's an honest schedule. The manager changes the closing shift to 3:30 PM to 9:45 PM, cutting a slow half hour at the start of the shift and scheduling the real closing time at the end. Scheduled and actual hours now match, labor stays about the same and nobody feels pressured to rush or stay unpaid.

Metrics to Watch

MetricFormulaWhat it tells you
Hours varianceActual − scheduled hoursHow far reality is from the plan
Variance %Variance ÷ scheduled hours × 100Size of the gap compared to the plan
Unplanned overtimeOvertime hours not on the scheduleOvertime you didn't budget for
Late punchesClock-ins after shift startAttendance patterns
Early or late outsClock-outs before or after shift endShifts running short or long
Missed punchesShifts with a missing punchTime record accuracy

Pick two or three to watch each week. Hours variance and unplanned overtime are the best place to start.

Talking to Your Team About the Gap

Employees are often the best source of information about why hours don't match the schedule. They know which tasks take longer than planned, which days are always busier and where time gets lost. Share the numbers with your team, without singling anyone out, and ask for ideas:

"Our closing shifts have been running about 40 minutes over the schedule most nights. I'd rather fix the schedule than have anyone rushing or staying unpaid. What's taking the time, and what would help?"

When people see that the goal is an accurate schedule and fair pay, not cutting their hours, they're much more likely to share what's really happening. Over time, that conversation leads to schedules that fit the work and fewer surprises at the end of every pay period.

Track Actual Hours Accurately With Updoot

Updoot's employee time clock records every punch to the minute, from a phone, browser or kiosk, with GPS punch locations so you can see where people clocked in. The payroll report shows regular hours, overtime and PTO for every employee each pay period, and the KPI dashboard puts hours worked next to budget vs. actual, so gaps show up while you can still fix them.

Sources

Related Reading

Labor Cost Percentage →

How to Track Employee Hours →

Employee Time Clock →

Frequently Asked Questions

What is the difference between scheduled hours and actual hours? ▶
Scheduled hours are the hours you planned for each shift. Actual hours are the hours employees really worked, based on time clock records.
How do you calculate schedule variance? ▶
Subtract scheduled hours from actual hours. Divide the difference by scheduled hours and multiply by 100 for a percentage.
Do I have to pay for hours that weren't scheduled? ▶
Yes. Under federal law, non-exempt employees must be paid for all hours actually worked, including time that wasn't scheduled or approved.
Is overtime based on scheduled or actual hours? ▶
Actual hours. Federal overtime applies to hours actually worked over 40 in a workweek for non-exempt employees.
Can I stop employees from clocking in early? ▶
You can set a policy on when employees may clock in and discipline employees who don't follow it, but you must pay for any time they actually work.
What causes shifts to run long? ▶
Common causes include closing tasks, call-outs, understaffed busy periods, early clock-ins, workflow bottlenecks and shift handoffs.
What is reporting time pay? ▶
In some states, such as California, employees who report to work as scheduled but are sent home early may be owed a minimum amount of pay. Check your state's rules.
How often should I compare scheduled and actual hours? ▶
Check daily for problem shifts, weekly for overtime risk and monthly for patterns.
What should a clock-in policy include? ▶
A clock-in window, when work starts, who approves overtime, what to do if work runs late, how to fix missed punches and a statement that all hours worked will be paid.
Should I share scheduled vs. actual hours data with employees? ▶
Sharing team-level patterns, without singling anyone out, often helps. Employees usually know why shifts run long and can suggest practical fixes.

Ready to try Updoot free?

Record every punch to the minute and see regular hours, overtime and PTO for each pay period, so the gap between plan and reality shows up early. Free to start.

Start Free Today