How to Calculate Payroll From Timesheets, Step by Step
Say an agency owner pays one employee for 82 hours over two weeks. Week 1 had 38 hours and Week 2 had 44. The payroll sheet pooled all 82 hours against an 80-hour biweekly limit and found 2 overtime hours.
Under a 40-hour weekly rule, the correct count is 4, because Week 2 went 4 hours past 40. At a $20 rate with overtime at $30, the employee is underpaid by $20, and someone has to explain that. Then the owner re-runs every payslip by hand to find out who else was pooled.
Raw tracked time should never be what you pay. Tracked minutes include idle blocks, forgotten timers and edits nobody reviewed. Pay those, and you will pay 90 idle minutes for one person, then fail to explain why a colleague on the same schedule got less.
The unit of payroll is approved hours, and the approval log is your real payroll document. This guide shows how to calculate payroll from timesheets by building one labelled sample employee through every step: split regular and overtime hours, add leave, and apply deductions.
Key Takeaways
- Tracked, attendance, payable and billable time are four different totals.
- Convert minutes by dividing by 60. So 7:45 is 7.75 hours, not 7.45.
- Judge overtime week by week. Never pool a biweekly period into one block.
- Every manual edit needs an approver and a record.
- Software moves approved hours into payslips. People still check rates, exceptions and local rules.
Table of Contents
- Turn Raw Timesheet Hours Into Payable Hours
- How to Calculate Payroll From Timesheets in One Worked Example
- What Should You Fix Before Approving Payroll?
- Check Local Rules, Then Automate the Workflow
- Frequently Asked Questions
Turn Raw Timesheet Hours Into Payable Hours
Keep four kinds of time apart before you do any arithmetic:
- Tracked time: what the app recorded on the computer.
- Attendance time: the first start to the last stop, minus breaks under your policy.
- Payable time: attendance hours after leave, approved edits and review.
- Billable time: hours you charge to a client, which is a separate question from how to calculate billable hours.
These totals differ after breaks, idle pauses, leave and edits. Payroll uses the payable one.
Timesheets show hours and minutes, but pay needs decimals. Divide the minutes by 60. Forty-five minutes is 45 ÷ 60 = 0.75, so 7:45 is 7.75 hours. Take a sample 8:15 day with an unpaid 30-minute break. That leaves 7:45, or 7.75 payable hours.
Here is a different sample week, with breaks already taken out (8:45 at the desk minus a 30-minute break is 8:15, or 8.25 hours):
- Monday to Thursday: 8.25 hours each, which is 33.00 hours
- Friday: 7.75 hours
- Weekly total: 40.75 hours
Most tracking tools pause the timer after a set idle period. Decide how many idle minutes pass before a block needs approval. A short limit sends more blocks to review. A long limit sends fewer, but more idle minutes slip into pay. Tracked time is a starting point.
Approval turns it into payable time. If you are unsure whether those pauses should be paid, read whether idle time counts as working hours before you set the rule.
How to Calculate Payroll From Timesheets in One Worked Example
Every number below is a sample. Our sample employee, Sample A, earns $20 an hour. The 40-hour workweek and the 1.5 overtime multiplier are sample settings, so the overtime rate is $30.
Split overtime week by week
Pooling a two-week period into one block hides overtime. Week 1 has 38 payable hours. Week 2 has 44. Overtime is judged per workweek, so Week 1 has 38 regular hours and no overtime. Week 2 has 40 regular hours and 4 overtime hours.
The period totals 78 regular hours and 4 overtime hours. Pooling the 82 hours against an 80-hour limit would show only 2 overtime hours. That understates overtime by 2 hours.
The threshold itself comes from the law. The US Department of Labor, for example, says most covered employees must get time-and-one-half for hours over 40 in a workweek, with exemptions (checked November 2026).
In Pakistan, weekly limits and overtime rates come from provincial factories and shops laws, and they differ by province and by type of workplace.
Check the current text for your province before you set the rule. Under a higher weekly limit, such as 48 hours, Week 2's 44 hours would carry no overtime at all, so the threshold changes the answer more than the method does. Also check whether bonuses must count toward the overtime rate.
That is a separate trap from hour counting.
Add leave, deductions and net pay
- Gross pay for worked hours: 78 × $20 = $1,560. Then 4 × $30 = $120. Worked-hours gross is $1,680.
- Paid leave: Sample A also took one approved paid leave day of 8 hours, logged apart from worked hours. It does not count toward the overtime threshold in this sample. 8 × $20 = $160. Gross is now $1,680 + $160 = $1,840.
- Unpaid leave: An hourly employee paid from tracked hours has no hours on an unpaid day, so nothing is subtracted. For salaried staff, deduct the daily rate for each unpaid day. For example, a sample $3,200 monthly salary over 20 working days gives a daily rate of $160, so one unpaid day takes off $160. Write your leave rules down before you run the numbers. This guide to a free leave management system shows how to set them up.
- Deductions: The employee took a $100 advance, agreed in writing to be repaid in two equal instalments. This period takes the first one: $100 ÷ 2 = $50. The next pay run takes the second $50. Tax withholding is left out of this sample, because the rates come from your tax authority's published tables.
- Net pay before tax: $1,840 − $50 = $1,790. Subtract the tax withheld, using the current official figures, to reach final take-home.
A simple worksheet row keeps the record:
Employee: Sample A | Period: Week 1-2 | Regular hrs: 78 | Overtime hrs: 4
Leave hrs: 8 (paid) | Rate: $20 | Deductions: $50 (advance, instalment 1 of 2)
Net before tax: $1,790 | Approver: Ops lead | Audit: Approved
What Should You Fix Before Approving Payroll?
A forgotten timer is the most common gap. The employee sends a request for the missing time. The admin approves or rejects it. The edit leaves a record, and that record matters. If a manager changes hours silently, nobody can later show why the pay changed.
Run this checklist before each pay run:
- Overnight shifts: Confirm the shift is assigned to the day it started.
- Duplicates: Look for overlapping entries for the same person.
- Missing punches: Ask for a time request. Do not guess the hours.
- Open timers: Check for anything running past a normal end of day.
Decide the pay rule for idle time and breaks first. Then apply it to everyone the same way. Admins can switch on optional screenshots, and staff are told about them. They help settle disputes about what was open on screen. They do not prove effort, so do not pay or deny pay on a screenshot alone.
Late marks follow a simple rule. A late mark appears when someone starts after the start time plus the grace period. It feeds attendance. Where your policy says so, it can also feed a deduction, as covered in salary deduction for late coming.
Use a three-column check
Compare tracked, payable attendance and billable client hours for each person. Write a reason for every gap. Here are sample figures for one week, for three other sample employees:
- Sample B: 41.00 tracked, 40.75 payable, 36.50 billable. A 0.25-hour idle block was removed, and 4.25 hours went on internal work.
- Sample C: 38.00 tracked, 40.00 payable, 32.00 billable. An approved missing-time request added 2.00 hours.
- Sample D: 44.00 tracked, 42.50 payable, 40.00 billable. A 1.50-hour idle block was rejected.
Check Local Rules, Then Automate the Workflow
Caution for global teams and Pakistan-based agencies. Check local labour and tax rules before you finalise any payroll. That covers monthly salaries, attendance-based deductions, approved overtime, public holidays, leave records and currency. Tracked hours alone do not decide employee status, tax or compliance.
A spreadsheet is enough for a few people on fixed hours with no overtime. Use one if that is you. Software starts to pay off when edits, leave, overtime and client invoices pile up.
Clockade's Mac and Windows apps record the hours, and the Chrome extension adds the websites used. The timer pauses after 3 to 15 minutes with no keyboard or mouse use, and your admin sets the limit.
Once hours are approved, Sample A's 78 regular hours, 4 overtime hours and 8 leave hours land in a payroll payslips draft. You then review the rate, the $50 deduction and the tax line.
You still review exceptions and confirm rates. You also apply local rules. If you need a country-specific statutory payroll engine or handle complex union rules, a dedicated payroll system fits better.
That is the practical answer on how to calculate payroll from timesheets without errors: pay approved hours, never raw tracked minutes, and keep the approval record. When overtime and edits pile up every month, Start with Clockade and run one pay period from real tracked hours.
Frequently Asked Questions
What if an employee forgets to start the timer?
They send a request for the missing time. The admin approves or rejects it, and the edit stays on record. Avoid typing hours into the timesheet by hand with no trail.
Should payroll use tracked computer time or approved attendance time?
Use approved time. Tracked time is the starting point. Breaks, leave, edits and your idle-time rule decide what becomes payable. Write the rule down and apply it to everyone.
How do I convert 7 hours 45 minutes to decimal hours?
Divide 45 minutes by 60 to get 0.75. Add it to 7 hours. The answer is 7.75 hours.
How is overtime worked out on a biweekly pay period?
Check each workweek on its own under the rule that applies to you. In our sample, 38 hours and 44 hours give 4 overtime hours, not 2. The 82-hour total is never one block.
Are lunch breaks, idle time and computer shutdown time paid?
That depends on your policy and local law. Many employers treat a set lunch break as unpaid and review idle blocks before approving them. Decide the rule first, then apply it the same way to every person.
Clockade turns your team's tracked time into attendance, leave, payroll and invoices. From $3 per person a month.
Start with ClockadeSee pricingMore from the blog
How to Track Time Spent on Apps and Websites FairlyScreen time shows habits, not payable hours. See what Clockade records on apps and websites, how to tell staff first, and how approved hours reach payroll.16 Nov 2026 · 8 min read
Employee Monitoring Software for Mac: A Buyer’s ChecklistTest the Mac agent before you buy: lid-close and wake, permissions, battery, Apple silicon. Then follow one approved hour into attendance, leave, payroll and invoices.16 Nov 2026 · 8 min read
Hubstaff vs Time Doctor: Which Fits Your Team?Hubstaff suits field staff, GPS and in-app payments. Time Doctor suits deeper review of desktop activity. See how each handles one overnight timer entry, from tracking to16 Nov 2026 · 7 min read