Calculate Weekly Overtime: 2026 Shift Math Blunders

How do you calculate weekly overtime for shift workers when you're still running things on a spreadsheet (and maybe a prayer)?

If you're managing a crew of shift workers — say, a handful of baristas, line cooks, or warehouse pickers — and you're tracking time on paper timesheets or a cobbled-together Google Sheet, you've probably felt that little knot in your stomach every Friday. The knot that says: Did I get the overtime right? Is someone getting shorted? Am I about to get a wage claim letter?

You're not alone. Plenty of small operations manage shift scheduling and payroll without dedicated HR software. It's doable. It's just also very easy to mess up — especially when shift patterns are irregular, breaks get skipped, and someone swaps a shift mid-week without telling you.

This guide walks through the actual mechanics of calculating weekly overtime manually, with a focus on the traps that catch managers most often. We'll keep it practical. Grab your timesheet.

What actually counts as overtime under FLSA rules?

Let's start with the basics, because this is where the first mistake lives.

Under the Fair Labor Standards Act (FLSA), non-exempt employees must receive overtime pay at one-and-a-half times their regular rate for all hours worked over 40 in a single workweek. Not per pay period. Not per shift. Per workweek.

Here's the pitfall: managers who run biweekly payroll sometimes calculate overtime based on the two-week total. So if someone works 38 hours week one and 44 hours week two, they think "82 hours, that's only 2 hours over 80, so 2 hours of OT." Wrong. That employee is owed 4 hours of overtime for week two, because each workweek stands alone.

A workweek is a fixed, recurring period of 168 hours — seven consecutive 24-hour periods. It doesn't have to align with the calendar week. You can define it as Monday through Sunday, Wednesday through Tuesday, whatever works. But once you pick it, stick with it. Changing your workweek definition to avoid paying overtime is a fast track to a labor violation.

How do you track varying shift times accurately without software?

Shift workers don't live in a neat 9-to-5 world. Someone might work 6:00 AM to 2:30 PM on Tuesday and then 11:00 AM to 7:00 PM on Thursday. If you're rounding those times or eyeballing them, you're introducing error into your overtime calculation before the math even begins.

The fix: use a standardized timesheet template

Create a simple spreadsheet (or even a printed form) where every shift is recorded with:

• Employee name
• Date
• Clock-in time (exact, to the minute)
• Clock-out time (exact, to the minute)
• Unpaid break duration (if applicable)
• Total hours worked for that shift

The key discipline here is recording actual times, not rounded ones. FLSA permits rounding to the nearest 15 minutes only if it averages out over time and doesn't consistently favor the employer. But when you're doing this manually, rounding just adds a layer of complexity that invites mistakes. Use real minutes. Do the subtraction. It's not that painful once you build the habit.

Calculating hours from clock times

Here's a quick refresher on the math, because people fumble this constantly. Say someone clocks in at 6:15 AM and clocks out at 2:45 PM, with a 30-minute unpaid lunch.

From 6:15 AM to 2:45 PM is 8 hours and 30 minutes. Subtract the 30-minute lunch. That's 8.0 hours worked.

If you're working in a spreadsheet, convert everything to decimal hours from the start. 15 minutes = 0.25 hours. 30 minutes = 0.5 hours. 45 minutes = 0.75 hours. This makes summing the week and applying the overtime multiplier dramatically simpler.

How do you calculate the regular rate of pay when hourly rates vary?

This is the trap that gets even diligent managers. If everyone on your team earns a single flat hourly rate, the regular rate is easy — it's just that rate. But many shift workers have varying rates. Maybe they earn a shift differential for nights. Maybe they get tips. Maybe they pick up shifts at a higher rate on weekends.

When that happens, the "regular rate of pay" for overtime purposes is not their base hourly rate. It's the weighted average of all earnings for the week divided by total hours worked.

Concrete example: weighted overtime calculation

Let's say you have an employee who works the following in a single workweek:

• 30 hours at $15/hour (day shifts) = $450
• 15 hours at $18/hour (night shift differential) = $270

Total hours worked: 45. Total straight pay: $720.

Regular rate of pay = $720 ÷ 45 = $16.00/hour.

Overtime rate = $16.00 × 1.5 = $24.00/hour.

Overtime hours = 45 − 40 = 5 hours.

Overtime pay = 5 × $24.00 = $120.

Total pay for the week = $720 + $120 = $840.

The common mistake here? Paying the 5 overtime hours at 1.5 × $18 (the last rate they worked at). That shortchanges the employee by $30 — and if you do that across multiple employees over multiple weeks, you're looking at a meaningful wage violation.

How do you handle overtime with split shifts and on-call time?

Split shifts — where someone works a morning block, takes a long unpaid break, and comes back for an evening block — are common in restaurants and hospitality. The good news is that the overtime calculation itself doesn't change. You sum all hours actually worked across both blocks and compare to 40.

The pitfall is in what counts as hours worked. If the break between shifts is long enough that the employee is completely free to use the time as they wish, it's unpaid. But if they're required to stay on premises, or if the break is shorter than 20 minutes, that time may need to be paid. Paid break time counts toward the 40-hour threshold.

On-call time is similar. If the employee can leave the premises and pursue personal activities, it's likely unpaid. If they're required to remain on-site or so close that they can't effectively use the time for themselves, it's probably paid time — and it counts toward overtime.

What's the step-by-step process for weekly overtime calculation?

Here's the workflow, distilled to its core steps. Follow this order every single week and you'll avoid most of the common errors:

Step 1: Define and confirm your workweek

Know exactly when your workweek starts and ends. Let's say it's Monday 12:00 AM through Sunday 11:59 PM. Every timesheet entry for the week must fall within that window.

Step 2: Collect and verify all timesheets

Get every employee's timesheet for the full workweek before you start calculating. Missing a shift entry and discovering it later means recalculating the entire week — and possibly correcting a prior payroll run.

Step 3: Calculate daily hours worked

For each day, subtract clock-out minus clock-in, then subtract unpaid breaks. Convert to decimal hours. Record this in a column per day.

Step 4: Sum the week

Add all daily hours together. If the total is 40 or fewer, there's no overtime. If it's over 40, the excess is your overtime hours.

Step 5: Determine the regular rate

If there's a single hourly rate, you're done — that's your regular rate. If rates varied or there's non-hourly compensation (commissions, non-discretionary bonuses), divide total straight-time earnings by total hours worked to get the weighted regular rate.

Step 6: Calculate overtime pay

Multiply overtime hours by the regular rate × 1.5. Add this to the total straight-time earnings. That's gross pay for the week.

Step 7: Document everything

Keep the timesheet, the calculation breakdown, and the final pay figure together. If there's ever a dispute or audit, you need to show your work — not just the final number.

What are the most common overtime mistakes (and how do you avoid them)?

We've touched on several already, but let's consolidate the biggest offenders:

Mistake 1: Calculating overtime per pay period instead of per workweek

Each workweek is independent. An employee who works 35 hours one week and 45 the next is owed 5 hours of OT — even though the two-week total is only 80.

Mistake 2: Excluding paid break time from the 40-hour calculation

Paid breaks count as hours worked. Only unpaid breaks are excluded. If you offer paid 15-minute breaks, those minutes push employees closer to (or over) the overtime threshold.

Mistake 3: Forgetting to include bonuses in the regular rate

Non-discretionary bonuses — meaning bonuses promised in advance, tied to performance or attendance — must be included in the regular rate calculation. A $100 attendance bonus earned during an overtime week retroactively changes the regular rate for that week.

Mistake 4: Rounding inconsistently

If you round clock-in times, you must round both up and down in a way that averages out over time. Rounding always in the employer's favor is a violation. When in doubt, don't round at all.

Mistake 5: Not tracking unauthorized overtime

If an employee works overtime you didn't approve, you still have to pay it. FLSA doesn't care about authorization — it cares about hours worked. Your recourse is disciplinary, not financial. Track the hours, pay the OT, address the behavior separately.

Can you make this sustainable without buying software?

Yes — but it requires building a repeatable system and having the discipline to follow it every week without shortcuts.

At minimum, create a spreadsheet template with columns for each day of your workweek, automatic decimal conversion, a running weekly total, and a conditional formula that flags any total over 40. Add a section at the bottom for the regular rate calculation and overtime pay. This won't replace HR software, but it will dramatically reduce the error surface compared to paper timesheets and mental math.

The managers who get burned on overtime aren't the ones without software. They're the ones without a system. Build the system, follow the steps, document your work, and those Friday knots in your stomach will become a lot less frequent.