Calculating Mixed Salaried and Hourly Weekly Pay Without Complicated Software
Thursday Afternoon, Payroll Due Friday
It's 3:47 PM on a Thursday. You're sitting in the truck cab between job sites, laptop balanced on the center console, and payroll runs tomorrow at 9 AM. You've got three project managers on salary who each pulled 50+ hours this week because the Henderson job went sideways. You've got five hourly field techs whose time cards look like they were written during an earthquake. And you've got your office coordinator — she's salaried for 30 hours a week but hourly for anything beyond that because she's been covering for your receptionist on medical leave.
Your "payroll system" is a spreadsheet you built in 2021. It has seventeen tabs. Three of them are named "DO NOT USE" and you use them anyway.
This is the weekly ritual for a lot of small field-service operators — landscapers, HVAC shops, electrical contractors, cleaning companies with mixed crews. You run a business where some people are paid for what they produce (a salary to manage a job site) and others are paid for the minutes they're on the clock. And every Friday, you have to turn that mess into correct paychecks without buying a $400/month payroll platform that your field crews would ignore anyway.
The Problem: Why Mixed Pay Breaks Your Brain Every Week
Here's what happens every single week. You open your time tracking app — the simple one your field techs actually use — and you see hours logged. Good. Then you open your salary spreadsheet. Different numbers. Different logic. Your salaried PMs don't track time the same way because "they're salary, so it doesn't matter." Except it does matter, because if they work over 45 hours, your company policy says they get comp time, and if they work over 50, you need to know that for job-costing purposes.
So you're manually reconciling two different pay philosophies — salaried pay (fixed weekly amount, sometimes with overtime nuances) and hourly pay (variable, tied to exact time entries) — using tools that were never designed to talk to each other. The result is that you spend three hours every Friday doing arithmetic that a middle schooler could handle, but at a scale and complexity that makes errors nearly guaranteed.
Last month you overpaid a field tech by $180 because his lunch break wasn't deducted. The month before, you underpaid your PM by $60 because you forgot her salary was prorated for a half-day off. These aren't catastrophic errors, but they erode trust. And trust is the only currency that matters when you're running crews in the field.
The Root Cause: You're Mixing Two Different Pay Logics in One Workspace
The reason this feels impossible isn't that the math is hard. It's that you're trying to calculate salaried weekly pay and hourly weekly pay in the same mental space, using the same spreadsheet, without separating the logic first.
Salaried pay is a deduction-based calculation. You start with the full weekly salary and subtract for missed time, partial days, or unpaid leave. Hourly pay is an accumulation-based calculation. You start at zero and add up every minute worked, then apply overtime rules.
These are opposite directions. When you try to do both in one spreadsheet tab — or worse, in one column — you create confusion. Your brain switches between "subtract from the total" and "add up from zero" fifty times in an hour, and that's where mistakes happen.
The fix isn't better software. The fix is separating the two calculations physically — different tabs, different columns, different workflows — and then combining the results at the end.
Step 1: Sort Your People Into Three Buckets Before Friday
Do this on Wednesday evening. Open your crew list and put every employee into one of three categories:
The Three Pay Buckets
- Pure Salaried: Fixed weekly pay, no overtime tracking needed for payroll (though you may track hours for job-costing). Example: Your project managers.
- Pure Hourly: Paid only for verified time entries. Overtime applies past 40 hours. Example: Your field techs and laborers.
- Hybrid: Salaried up to a set number of hours, hourly beyond that. Example: Your office coordinator who's salaried for 30 hours but hourly after that.
This takes ten minutes. But it saves you an hour on Friday because you're not mentally switching contexts every time you look at a different employee. Each bucket gets its own calculation method, its own spreadsheet tab, and its own verification step.
Step 2: Calculate Salaried Weekly Pay (Deduction Method)
For pure salaried employees, start with the full weekly amount and work backward. Let's say your PM earns $1,200 per week. Here's the calculation:
Full weekly salary: $1,200
Prorated deductions: Did they take a half-day off? Did they leave early? Convert any missed time to a fraction of the week and subtract.
Result: $1,200 minus any deductions.
Example: Your PM took Friday afternoon off — 4 hours out of a 40-hour expected week. That's 10% of the week. Deduction = $120. Final weekly pay = $1,080.
Do this in a dedicated tab called "Salary Calculations" with three columns: Employee Name, Weekly Salary, Deduction Amount, Final Pay. That's it. No time entries in this tab. No hourly rates. Keep it clean.
Step 3: Calculate Hourly Pay (Accumulation Method)
Now switch to a different tab — "Hourly Calculations". Here, you're building up from zero. Pull your time tracking data for the week and organize it by employee.
For each hourly employee, you need four numbers:
- Regular hours (up to 40)
- Overtime hours (anything over 40)
- Regular rate
- Overtime rate (1.5x regular, unless your state or contract says otherwise)
Example: Your field tech worked 46.5 hours this week. Regular rate is $22/hour.
Regular pay: 40 hours × $22 = $880
Overtime pay: 6.5 hours × $33 = $214.50
Total weekly pay: $1,094.50
The key here is that your time tracking tool does the heavy lifting on the hours. You're not adding up punch cards. You're exporting a weekly summary and dropping the numbers into a simple formula. If your time tracking app can't export a weekly hours summary per employee, you need a different time tracking app — not a different payroll system.
Step 4: Handle the Hybrid Employee Without Losing Your Mind
This is the one that trips everyone up. Your office coordinator is salaried for 30 hours at $600/week, but hourly at $20/hour for anything beyond 30 hours, with overtime at 1.5x after 40 total hours.
Here's how to handle it cleanly:
Step A: Check her total hours for the week. Let's say she worked 44 hours.
Step B: The first 30 hours are covered by her $600 salary. No calculation needed.
Step C: Hours 31–40 (10 hours) are paid at her hourly rate: 10 × $20 = $200.
Step D: Hours 41–44 (4 hours) are overtime: 4 × $30 = $120.
Total weekly pay: $600 + $200 + $120 = $920.
Put hybrid employees in their own tab. The logic is different enough that mixing them with pure hourly or pure salaried people will cause errors. Label the tab "Hybrid Pay" and use four columns: Base Salary, Hourly Tier Hours, Overtime Hours, Total Pay.
Step 5: Combine and Verify — The Friday Morning Sweep
Now you have three tabs with final numbers. Open a fourth tab called "Weekly Payroll Summary." This is the only tab you'll look at when you write checks or submit direct deposit.
Copy the final pay amount for every employee into this summary tab, sorted by pay type. Add them up. Compare the total to last week's total. If this week's total is 30% higher than last week's and you didn't add staff or run overtime on a big job, something's wrong. A variance check takes 90 seconds and catches 80% of errors.
Then spot-check one salaried employee, one hourly employee, and the hybrid employee. Manually recalculate their pay from scratch on a piece of paper. If the numbers match the spreadsheet, you're good. If they don't, find the error before you submit payroll — not after.
Make It Repeatable: Your Weekly Payroll Routine
The goal isn't to build a perfect system. The goal is to build a repeatable one — something you can do in your truck cab on a Thursday afternoon without wanting to throw the laptop out the window.
Here's the routine that works after you've set up the tabs:
- Wednesday evening (15 min): Sort employees into buckets. Note any anomalies — someone on vacation, someone who worked a double shift.
- Thursday afternoon (45 min): Export time tracking data. Fill in the hourly tab. Fill in the salary tab. Fill in the hybrid tab.
- Thursday evening (15 min): Combine into the summary tab. Run the variance check. Spot-check three employees.
- Friday morning: Submit payroll. Drink coffee. Go run your actual business.
Total time: about 75 minutes. No expensive software. No complicated integrations. Just a spreadsheet with clear logic, a time tracking tool that your field crews actually use, and a routine that respects the fact that salaried pay and hourly pay are two different animals.
The operators who nail this aren't the ones with the fanciest payroll platforms. They're the ones who separate the logic, automate the time capture, and verify with a variance check. That's it. That's the whole system. And once you run it for three weeks, it becomes muscle memory — which means your Thursday afternoons go back to being about job sites and crew management, not arithmetic.