How Do I Calculate Work Hours for Payroll?
To calculate work hours for payroll, record each employee’s start time, end time, and unpaid breaks for every workday. Subtract unpaid break time, total the paid hours for the pay period, convert minutes into decimals, then multiply those hours by the employee’s pay rate. If the employee is non-exempt and works overtime, calculate overtime separately according to the rules that apply in your location.
Here is the basic formula:
Payroll hours = clock-out time – clock-in time – unpaid breaks
Gross pay = regular hours x regular rate + overtime hours x overtime rate
For example, if an employee works from 9:00 AM to 5:30 PM and takes a 30-minute unpaid lunch, the paid time is 8 hours. If their hourly rate is $20, their gross pay for the day is:
8 hours x $20 = $160
That is the simple version. The tricky parts are usually minutes, lunch breaks, overnight shifts, rounding, overtime, missed punches, and employees who work across projects or pay rates. This guide walks through each part with examples you can use before running payroll.
Step 1: Collect Accurate Clock-In and Clock-Out Times
Start with a reliable time record for each employee. At minimum, a payroll-ready time record should include:
- Employee name or ID
- Work date
- Clock-in time
- Clock-out time
- Unpaid break duration
- Paid break duration, if applicable
- Job, project, client, or department, if you track cost allocation
- Manager approval or timesheet confirmation
Manual timesheets can work for very small teams, but they become harder to trust as the team grows. If employees work remotely, across multiple projects, or on flexible schedules, automated time tracking can reduce payroll cleanup. Backlsh’s guide to automatic project time tracking is a useful next read if you need payroll hours tied to real project activity.
Step 2: Convert Start and End Times Into Total Time Worked
For each shift, subtract the start time from the end time.
Example:
| Clock in | Clock out | Total time |
|---|---|---|
| 8:45 AM | 5:15 PM | 8 hours 30 minutes |
Then subtract unpaid breaks.
| Total time | Unpaid lunch | Paid work time |
|---|---|---|
| 8 hours 30 minutes | 30 minutes | 8 hours |
If your team uses 24-hour time, the same shift is:
| Clock in | Clock out | Total time |
|---|---|---|
| 08:45 | 17:15 | 8 hours 30 minutes |
For overnight shifts, calculate across midnight carefully.
Example:
| Clock in | Clock out | Total time |
|---|---|---|
| 10:00 PM | 6:00 AM | 8 hours |
Do not subtract from 10 to 6 directly. Treat the shift as 10:00 PM to midnight, then midnight to 6:00 AM:
2 hours + 6 hours = 8 hours
Step 3: Subtract Unpaid Breaks
Only subtract breaks that are unpaid under your policy and applicable labor rules. For payroll purposes, the important distinction is whether the break is paid or unpaid.
Example:
| Shift | Time at work | Break | Paid hours |
|---|---|---|---|
| 9:00 AM to 6:00 PM | 9 hours | 1 hour unpaid lunch | 8 hours |
| 9:00 AM to 5:15 PM | 8 hours 15 minutes | 30 minutes unpaid lunch | 7 hours 45 minutes |
| 8:00 AM to 4:00 PM | 8 hours | No unpaid break | 8 hours |
The key is consistency. If employees forget to clock out for lunch, do not simply assume a break happened. Confirm and correct the timesheet before payroll is finalized.
Step 4: Convert Minutes to Decimal Hours
Payroll systems usually need hours as decimals, not hours and minutes. To convert minutes to decimal hours, divide the minutes by 60.
Decimal hours = minutes / 60
Common conversions:
| Minutes | Decimal |
|---|---|
| 5 minutes | 0.08 |
| 10 minutes | 0.17 |
| 15 minutes | 0.25 |
| 20 minutes | 0.33 |
| 30 minutes | 0.50 |
| 45 minutes | 0.75 |
Example:
An employee works 7 hours and 45 minutes.
45 / 60 = 0.75
So the payroll entry is:
7.75 hours
If their rate is $22 per hour:
7.75 x $22 = $170.50
Step 5: Add Daily Hours for the Pay Period
Once each shift is calculated, total the paid hours for the full pay period.
Example weekly timesheet:
| Day | Paid time | Decimal hours |
|---|---|---|
| Monday | 8 hours 0 minutes | 8.00 |
| Tuesday | 7 hours 45 minutes | 7.75 |
| Wednesday | 8 hours 15 minutes | 8.25 |
| Thursday | 8 hours 0 minutes | 8.00 |
| Friday | 8 hours 30 minutes | 8.50 |
| Total | 40 hours 30 minutes | 40.50 |
If the employee earns $25 per hour and no overtime applies:
40.50 x $25 = $1,012.50
If overtime applies after 40 hours in the workweek, split the hours:
- Regular hours: 40.00
- Overtime hours: 0.50
At $25 per hour, overtime at 1.5x is $37.50 per hour.
Regular pay: 40 x $25 = $1,000
Overtime pay: 0.50 x $37.50 = $18.75
Gross pay: $1,018.75
Step 6: Calculate Overtime Separately
For US employers, the Fair Labor Standards Act generally requires non-exempt employees to receive overtime pay at at least 1.5 times their regular rate for hours worked over 40 in a workweek. State or local rules may be stricter, so always check the rules that apply to your employees.
Basic overtime formula:
Overtime pay = overtime hours x regular rate x 1.5
Example:
An employee works 46 hours in a week and earns $18 per hour.
- Regular hours: 40
- Overtime hours: 6
- Overtime rate: $18 x 1.5 = $27
Payroll calculation:
40 x $18 = $720
6 x $27 = $162
Gross pay = $882
What if the employee has two pay rates?
This is where many manual payroll calculations go wrong. If a non-exempt employee works at two hourly rates in the same workweek, the overtime calculation may need to use a weighted average regular rate unless a valid alternative method applies.
Example:
An employee works:
- 30 hours at $20 per hour
- 15 hours at $30 per hour
- Total hours: 45
Straight-time earnings:
30 x $20 = $600
15 x $30 = $450
Total straight-time earnings = $1,050
Weighted regular rate:
$1,050 / 45 hours = $23.33
Because the employee already received straight-time pay for all 45 hours, the extra overtime premium is one-half of the regular rate for the 5 overtime hours:
$23.33 x 0.5 x 5 = $58.33
Total gross pay:
$1,050 + $58.33 = $1,108.33
This is one reason project-based time tracking matters. If employees move between roles, clients, or rates, your payroll process needs clean time allocation. Backlsh’s article on time tracking in project management explains how project-level time data helps teams avoid messy end-of-week reconstruction.
Step 7: Decide How You Handle Rounding
Some employers round clock-in and clock-out times to the nearest 5 minutes, 6 minutes, or 15 minutes. Rounding can be allowed under federal guidance when it is neutral and does not systematically underpay employees over time.
Example of 15-minute rounding:
| Actual time | Rounded time |
|---|---|
| 8:07 AM | 8:00 AM |
| 8:08 AM | 8:15 AM |
| 5:22 PM | 5:15 PM |
| 5:23 PM | 5:30 PM |
Rounding should not always favor the employer. If your rounding practice regularly cuts paid time from employees, it can create wage and hour risk. For many teams, exact-to-the-minute tracking is cleaner and easier to explain.
Step 8: Review, Approve, and Lock the Timesheet
Before payroll is processed, review timesheets for:
- Missed clock-ins or clock-outs
- Duplicate shifts
- Unusually long shifts
- Unpaid breaks that were auto-deducted without confirmation
- Overtime that needs manager approval
- Time assigned to the wrong client, department, or project
- Employees working before or after scheduled hours
Once corrections are made, have the employee or manager approve the timesheet. Then lock the payroll period so hours are not edited after payroll is run without a clear adjustment process.
For remote teams, this review process should be transparent. You want accurate payroll, not a surveillance culture. Backlsh’s guide on how to track remote employee productivity without being creepy is helpful if you are balancing accountability with employee trust.
Full Payroll Calculation Example
Here is a complete example for one hourly employee.
Employee:
- Hourly rate: $24
- Overtime rate: $36
- Overtime rule used in this example: over 40 hours in a workweek
Timesheet:
| Day | Clock in | Clock out | Unpaid break | Paid hours |
|---|---|---|---|---|
| Monday | 8:30 AM | 5:00 PM | 30 min | 8.00 |
| Tuesday | 8:45 AM | 5:30 PM | 45 min | 8.00 |
| Wednesday | 8:30 AM | 6:00 PM | 30 min | 9.00 |
| Thursday | 9:00 AM | 6:00 PM | 30 min | 8.50 |
| Friday | 8:30 AM | 5:30 PM | 30 min | 8.50 |
| Total | 42.00 |
Payroll:
- Regular hours: 40
- Overtime hours: 2
- Regular pay: 40 x $24 = $960
- Overtime pay: 2 x $36 = $72
- Gross pay: $1,032
Case Study 1: A Retail Team With Missed Lunch Punches
A small retail business had 12 hourly employees and calculated payroll from handwritten timesheets. The most common issue was lunch. Employees often wrote a start and end time but forgot to record whether lunch was 30, 45, or 60 minutes.
Before:
- Payroll took 3 to 4 hours every two weeks
- Managers had to message employees to confirm breaks
- Two employees disputed their hours in the same month
Improved process:
- Employees clocked in and out digitally
- Lunch breaks were recorded as actual time, not assumed time
- Managers reviewed exceptions each Friday
- Payroll exported only approved hours
Result:
Payroll review became more about exceptions than reconstruction. The business still needed human approval, but the time records were complete enough that payroll did not depend on memory.
Lesson:
If unpaid breaks affect payroll, make break tracking explicit. Auto-deducting breaks may look efficient, but it can create problems if employees work through lunch or take a shorter break than expected.
Case Study 2: A Remote Agency Tracking Billable and Payroll Hours
A remote marketing agency paid employees hourly and billed clients by project. The problem was not just “how many hours did people work?” It was “which client or project should those hours be assigned to?”
Before:
- Employees submitted weekly summaries from memory
- Payroll hours and billable hours did not always match
- Project profitability reports were unreliable
Improved process:
- Team members tracked time by project during the day
- Managers reviewed weekly totals before payroll
- Admin time, client work, and internal meetings were separated
- Payroll used total approved hours, while reporting used project-level hours
Result:
Payroll became more accurate, and the agency could see which projects were consuming more time than estimated.
Lesson:
Payroll accuracy and project profitability often depend on the same foundation: clean time data. If your team bills clients or tracks budgets, read Backlsh’s guide to timesheets for consultants for a deeper look at consultant and client-service workflows.
Case Study 3: A Flexible-Hours Startup With Overtime Risk
A startup allowed flexible working hours. Employees could start early, work late, or split their day. The policy was popular, but hourly non-exempt employees sometimes crossed 40 hours without managers noticing until payroll.
Before:
- Flexible hours were tracked loosely
- Managers saw overtime only after the pay period ended
- Payroll costs fluctuated unexpectedly
Improved process:
- Employees tracked hours daily
- Managers received alerts when someone approached 40 hours
- Overtime was reviewed before extra hours were worked
- The company kept flexible scheduling but made payroll visibility weekly
Result:
The company kept flexibility without treating overtime as a surprise. Employees were still paid for all hours worked, and managers had better planning data.
Lesson:
Flexible schedules still need clear timekeeping. Flexibility is easier to manage when hours are visible before payroll closes. Backlsh’s article on flexible working hours can support this section with broader policy context.
Common Payroll Hour Calculation Mistakes
Mistake 1: Using hours and minutes as if they were decimals
Do not enter 7 hours and 30 minutes as 7.30. It should be 7.50.
Why:
30 minutes is half of an hour, so it equals 0.50.
Mistake 2: Forgetting to subtract unpaid breaks
If an employee is at work from 9:00 AM to 5:30 PM and takes a 30-minute unpaid lunch, paid time is 8 hours, not 8.5 hours.
Mistake 3: Subtracting breaks that employees did not actually take
If an employee works through an unpaid lunch, you may need to count that time as hours worked. Confirm the timesheet instead of relying on assumptions.
Mistake 4: Calculating overtime by pay period instead of workweek
Under federal FLSA rules, overtime is generally based on hours worked over 40 in a workweek for non-exempt employees. A biweekly pay period does not let you average 30 hours in one week and 50 hours in the next to avoid overtime.
Mistake 5: Ignoring off-the-clock work
If employees start work before clocking in, answer work messages after clocking out, or continue working during lunch, those hours may still need to be counted. Train managers to prevent off-the-clock work and correct records when it happens.
Mistake 6: Rounding only in the employer’s favor
Rounding should be neutral over time. If your rounding method consistently reduces paid time, it is a risk.
Mistake 7: Waiting until payroll day to fix timesheets
Payroll day should not be detective day. Review exceptions daily or weekly so missing punches and unclear breaks are fixed while people still remember what happened.
Payroll Hours Calculation Cheat Sheet
Use this quick workflow:
- Record clock-in and clock-out times.
- Subtract unpaid breaks.
- Convert minutes to decimals by dividing minutes by 60.
- Add all paid hours for the workweek or pay period.
- Separate regular and overtime hours.
- Apply the correct pay rate or weighted regular rate.
- Review exceptions and approve the timesheet.
- Export or enter the approved hours into payroll.
Quick decimal formula:
Hours + minutes / 60 = payroll decimal hours
Examples:
- 8 hours 15 minutes = 8 + 15/60 = 8.25
- 6 hours 30 minutes = 6 + 30/60 = 6.50
- 9 hours 45 minutes = 9 + 45/60 = 9.75
If you want to check the math quickly before payroll, use Backlsh’s work hours calculator to convert shifts, breaks, and totals into payroll-ready hours.
Should You Calculate Payroll Hours Manually or Use Software?
Manual payroll hour calculations can work when you have only a few employees, fixed schedules, and simple hourly rates. But manual work becomes risky when you have:
- Remote employees
- Flexible schedules
- Contractors or consultants
- Multiple projects or clients
- Overtime
- Different pay rates
- Missed punches
- Payroll integrations
- Productivity or utilization reporting needs
Software is usually worth it when the cost of payroll mistakes, admin time, or employee disputes is higher than the cost of the tool. If you are comparing options, Backlsh’s guide to monthly pricing of timesheet management tools can help evaluate the tradeoff.
For freelancers and small teams that want a lighter setup, see Backlsh’s freelance time tracker download guide.
FAQ
How do I calculate payroll hours from clock-in and clock-out times?
Subtract the clock-in time from the clock-out time, then subtract unpaid breaks. Convert any remaining minutes into decimals by dividing by 60.
Example:
9:00 AM to 5:30 PM = 8 hours 30 minutes.
Minus 30-minute unpaid lunch = 8 paid hours.
How do I convert minutes for payroll?
Divide the minutes by 60.
Examples:
- 15 minutes = 0.25 hours
- 30 minutes = 0.50 hours
- 45 minutes = 0.75 hours
Is 7 hours and 30 minutes entered as 7.30 or 7.50?
Enter it as 7.50. Payroll decimals are based on fractions of an hour, not clock minutes.
How do I calculate overtime hours?
For a simple US federal example, if a non-exempt employee works 46 hours in a workweek, 40 hours are regular hours and 6 hours are overtime hours. Multiply overtime hours by the applicable overtime rate, often 1.5 times the regular rate. Check state and local rules because some locations have additional overtime requirements.
Do I need to pay for time worked before clocking in?
If the employee was allowed or required to work, that time may need to be counted even if it was not properly recorded. The best practice is to correct the time record and train managers not to permit off-the-clock work.
Can I round employee time for payroll?
Rounding may be allowed if it is neutral and does not consistently underpay employees. Many employers avoid rounding issues by tracking exact time instead.
What is the easiest way to calculate work hours for payroll?
The easiest reliable method is to use a digital timesheet or time tracking tool that records clock-in, clock-out, breaks, approvals, and exports decimal hours for payroll. Manual spreadsheets can work, but they require careful review.
Final Takeaway
Calculating work hours for payroll is simple when the time record is complete:
Clock out – clock in – unpaid breaks = paid work hours
Then convert minutes to decimals, total the hours, separate overtime, and multiply by the correct pay rate.
The real challenge is not the math. It is getting accurate, approved time data before payroll runs. A clear time tracking process helps employers pay people correctly, reduce payroll disputes, and understand where team time is actually going.
Suggested Internal Links Used
- Automatic Project Time Tracking: Complete Guide 2026
- Time Tracking in Project Management: Why It Matters and How to Do It Right
- Track Remote Employee Productivity Without Being Creepy
- Timesheets for Consultants
- Flexible Working Hours: Are They Better for Your Company?
- Compare Monthly Pricing of Popular Timesheet Management Tools
- Freelance Time Tracker Download
- Work Hours Calculator
Sources and Editorial References
- US Department of Labor, Wage and Hour Division: Fact Sheet #23: Overtime Pay Requirements of the FLSA
- US Department of Labor, Wage and Hour Division: Fact Sheet #22: Hours Worked Under the FLSA
- eCFR: 29 CFR 785.48, Use of Time Clocks
- eCFR: 29 CFR 778.105, Determining the Workweek
- OnTheClock: How to Calculate Hours Worked Like a Pro