How to Calculate Payroll Hours: The Complete Guide to Decimal Time Conversion
Divide your minutes by 60, add that to your whole hours, multiply by the pay rate. Seven hours 45 minutes becomes 7.75, and 7.75 times $18.00 is $139.50. That's it. Below is the actual math for a full biweekly paycheck, the FLSA rounding rules that trip up more employers than you'd expect, and three Excel formulas so you don't have to do any of this by hand.
What This Guide Covers
- Why payroll systems require decimal hours, not HH:MM
- The exact formula: hours + (minutes ÷ 60)
- 5-step process from time card to gross pay
- FLSA rounding rules & the 7-minute rule
- 4 worked examples: hourly, part-time, overtime, freelance
- 3 Excel formulas for automatic decimal conversion
- Complete 60-row minutes-to-decimal reference chart
The Core Formula
gross pay = decimal hours × hourly rate
Why Payroll Uses Decimal Hours Instead of HH:MM
Time runs on base-60 math. The Babylonians invented it roughly 4,000 years ago. Sixty seconds per minute, sixty minutes per hour. It works great for reading a clock. It breaks the second you try to multiply it by a dollar amount.
Try adding 7h 45m and 6h 30m on paper. Most people write 13h 75m. But 75 minutes is 1 hour and 15 minutes, so the real answer is 14h 15m. That's an error before you've touched the pay rate. And multiplying 7:45 by $18.50 isn't possible on a basic calculator. There's no direct path from clock format to dollars.
Convert 7:45 to 7.75 first, and suddenly it's 7.75 times $18.50 = $143.38. Gross pay before taxes and deductions. That's why payroll systems use decimal hours. Base-60 clock math doesn't fit in a formula. Decimals do.
Once you're in decimal, 15 minutes is 0.25, 30 is 0.50, 45 is 0.75. These add and multiply like any other number. No rollover logic, no conversion tricks. ADP, QuickBooks Payroll, and Gusto all work this way internally, even if the interface shows you clock format on screen.
Methodology note: All worked examples in this guide use the FLSA decimal conversion formula. Rounding rules are sourced from 29 CFR § 785.48, the federal regulation governing hours-worked rounding.
The Formula: Converting Time to Decimal Hours
What "decimal hours" actually means
Decimal hours are regular numbers. The digits after the decimal point are just a fraction of one full hour. So 0.5 is half an hour (30 minutes). 0.25 is a quarter hour (15 minutes). 0.75 is three quarters (45 minutes). Multiply any of these by a pay rate and you get a dollar amount. That's the payoff.
The formula: decimal hours = hours + (minutes / 60). If your time clock captures seconds, add a third term:
The full formula
decimal hours = hours + (minutes ÷ 60) + (seconds ÷ 3600)
Seconds are usually omitted in manual payroll; use all three terms with electronic time-clock systems.
Three quick examples to show how it works in practice:
| Clock Time | Calculation | Decimal Hours |
|---|---|---|
| 7h 30m | 7 + (30 ÷ 60) | 7.5 |
| 8h 15m | 8 + (15 ÷ 60) | 8.25 |
| 6h 45m | 6 + (45 ÷ 60) | 6.75 |
⚡ Skip the Math — Use Our Free Calculator
Enter any hours and minutes combination for an instant decimal result, including totals for a full timesheet.
→ Open Free CalculatorCalculate Payroll Hours: Step by Step
One employee, $17.00/hr, ten working days in a biweekly period. All the math is shown.
Collect the time records
Pull every clock-in and clock-out for the period. Physical card, mobile app, kiosk, handwritten sheet, whatever you're using. For this example that's ten days in HH:MM format. Check that every shift has both a start and an end. Flag unpaid breaks now. One missing punch is much easier to fix before you run payroll than after.
Get each shift's total in raw minutes
Don't subtract hours and minutes separately. Convert everything to raw minutes first. Clock-out at 16:30 is 990 minutes from midnight. Clock-in at 8:00 is 480. Difference: 510 minutes. Subtract 30 for an unpaid lunch break and you have 480 minutes, which is exactly 8 hours. Working in minutes keeps things clean before you touch any decimals.
Convert each day's total to decimal hours
Apply the formula to each daily total: hours plus (minutes divided by 60). The ten days in this example give you: 8.00, 9.00, 8.50, 8.50, 8.00 for Week 1, and 8.00, 8.75, 8.25, 9.00, 7.75 for Week 2. Round to two decimal places. If your clock captures seconds, add (seconds / 3600) as a third term.
Add up the decimal hours, but keep weeks separate
Week 1: 8.00 + 9.00 + 8.50 + 8.50 + 8.00 = 42.00 hours. Week 2: 8.00 + 8.75 + 8.25 + 9.00 + 7.75 = 41.75 hours. Biweekly total: 83.75 hours. Don't combine them yet. You need those weekly subtotals for the overtime check in Step 5.
Multiply by the pay rate
Week 1 had 42.00 hours, so 2.00 are overtime. Week 2 had 41.75, so 1.75 are overtime. That gives you 80 straight-time hours and 3.75 overtime hours across the period. Regular pay: 80 times $17.00 = $1,360.00. The overtime premium is half the regular rate: $8.50/hr. Premium: 3.75 times $8.50 = $31.88. Total gross: $1,391.88. Tax withholdings, benefits, and deductions come after this number.
FLSA Payroll Rounding Rules
What Is the 7-Minute Rule?
The 7-minute rule is the most widely used application of FLSA quarter-hour rounding. Minutes 1–7 past any quarter-hour round down; minutes 8–14 round up to the next quarter. A clock-out at 4:22 PM rounds to 4:15 PM. A clock-out at 4:23 PM rounds to 4:30 PM. See FLSA guidance from the Department of Labor →
The FLSA, enforced by the Department of Labor's Wage and Hour Division, lets employers round employee time for payroll. But there's a condition, spelled out in 29 CFR § 785.48: rounding has to be neutral. Over time, it can't consistently take money from workers. If your system always rounds in the employer's direction, that's a wage violation, intended or not. In 2025, the DOL recovered nearly $600,000 in back wages from a single construction company for improperly applied rounding practices.
Three methods dominate U.S. payroll. Quarter-hour rounding is the most common by far. Six-minute rounding (one-tenth of an hour) is popular in law firms and consulting shops that already bill in 0.1-hour increments. Nearest-minute rounding is growing in software-based systems that have no technical reason to round at all, but do it out of habit.
Quarter-hour rounding: minutes 1 through 7 past any quarter-hour round down, 8 through 14 round up. Clock-out at 4:07 becomes 4:00. Clock-out at 4:08 becomes 4:15. Four points per hour: :00, :15, :30, :45. Six-minute rounding splits the hour into ten equal segments and applies the same midpoint logic inside each one.
| Actual Minutes | Rounds To (15-min method) | Rounds To (6-min method) |
|---|---|---|
| 1 – 7 min | 0 min (round down) | 0 min (0.0 hr) |
| 8 – 14 min | 15 min (0.25 hr) | 6 min (0.1 hr) |
| 15 – 22 min | 15 min (0.25 hr) | 18 min (0.3 hr) |
| 23 – 29 min | 30 min (0.5 hr) | 24 min (0.4 hr) |
| 30 – 37 min | 30 min (0.5 hr) | 30 min (0.5 hr) |
| 38 – 44 min | 45 min (0.75 hr) | 36 min (0.6 hr) |
| 45 – 52 min | 45 min (0.75 hr) | 48 min (0.8 hr) |
| 53 – 59 min | 60 min (1.0 hr, next hour) | 54 min (0.9 hr) |
FLSA Compliance Note
Whichever rounding method you choose, apply it consistently to all employees and review it periodically. If an audit shows employees are consistently losing time due to rounding, the DOL Wage and Hour Division (WHD) may require back-pay corrections. Reference: DOL Fact Sheet #23 — Overtime Pay Requirements of the FLSA →. When in doubt, consult a qualified employment attorney or payroll professional.
2026 State Law Alert: Rounding May Not Be Legal Everywhere
Federal FLSA rounding rules apply nationwide, but California, Oregon, and Washington courts are actively restricting time rounding for employers using digital timekeeping. They're pushing toward a strict "pay-to-the-minute" standard. A California Supreme Court ruling on this issue is anticipated in 2026. If you operate in any of these states, consult a local employment attorney before implementing a rounding policy. Federal rules are a floor, not a ceiling. See DOL state labor office contacts →
4 Worked Examples
A clean 40-hour week, an irregular part-time schedule, an overtime week, and a freelancer juggling three clients at different rates. All the arithmetic is shown.
Example 1 Full-Time Hourly Employee — Standard 40-Hour Week at $16.50/hr
Daily time log: Mon 8h 00m · Tue 7h 45m · Wed 8h 30m · Thu 8h 00m · Fri 7h 45m
Convert each to decimal: 8.00 + 7.75 + 8.50 + 8.00 + 7.75 = 40.00 hours. No overtime. Gross pay = 40.00 × $16.50 = $660.00.
Example 2 Part-Time Employee — Irregular Bi-Weekly Schedule at $22.00/hr
Week 1: 5h 15m, 6h 00m, 4h 45m, 5h 30m → Week 2: 6h 15m, 5h 00m, 4h 30m, 6h 45m
Week 1 decimal: 5.25 + 6.00 + 4.75 + 5.50 = 21.50 hrs. Week 2 decimal: 6.25 + 5.00 + 4.50 + 6.75 = 22.50 hrs. Total: 44.00 hours. No week exceeds 40 hours, so no OT. Gross pay = 44.00 × $22.00 = $968.00.
Example 3 Overtime Week — Hours Over 40, 1.5× Rate at $18.00/hr
Daily log: Mon 9h 30m · Tue 9h 00m · Wed 9h 15m · Thu 8h 45m · Fri 9h 00m
Decimal totals: 9.50 + 9.00 + 9.25 + 8.75 + 9.00 = 45.50 hours. Regular hours: 40.00 × $18.00 = $720.00. Overtime hours: 5.50 × ($18.00 × 1.5) = 5.50 × $27.00 = $148.50. Total gross = $868.50.
Example 4 Freelancer — Multiple Clients, Different Rates
Client A: 12h 20m @ $75/hr · Client B: 8h 45m @ $50/hr · Client C: 5h 10m @ $95/hr
Client A: 12 + (20÷60) = 12.333 hrs × $75 = $925.00. Client B: 8.75 hrs × $50 = $437.50. Client C: 5 + (10÷60) = 5.167 hrs × $95 = $490.83. Total invoice = $925.00 + $437.50 + $490.83 = $1,853.33.
Common Payroll Calculation Mistakes
The errors that run quietly for months
Most payroll errors aren't careless slip-ups. They're systematic. The same wrong thing runs every pay period until a wage audit or a frustrated employee surfaces it. Here are the six that come up most.
- Multiplying the raw clock number by the pay rate. This is the expensive one. 8:45 is 8.75 hours, not 8.45. At $20/hr, that 0.30-hour gap costs an employee $6.00 per shift. Run it 250 days a year and one person is short $1,500. Always multiply by the converted decimal, never the raw clock number.
- Rounding in one direction every time. If your system consistently shaves time off clock-out totals, that's not a rounding policy. It's wage theft, even if it's unintentional. The FLSA requires rounding to be neutral in aggregate. Audit your raw punch data against rounded totals at least quarterly to confirm it's actually balanced.
- Your electronic time clock captures to the second. If it exports 7:44:52, the right decimal is 7 + (44/60) + (52/3600) = 7.748. Truncating to 7:44 gives you 7.733. That's a 54-second error per punch. Small per shift, significant across hundreds of employees over a year.
- Mixing formatted time cells with typed decimal numbers in a spreadsheet. "8:30" and "8.5" look nearly identical in Excel. They're stored completely differently. Excel holds 8:30 as a fraction of a day (roughly 0.354), not the number 8.5. SUM a column with both types and you'll get garbage with no error flag. Pick one format per column and don't mix them.
- Forgetting to multiply by 24 in Excel. Excel stores 8:30 as 0.354 internally. SUM a week of time-formatted cells, format that result as a number, and you might see 2.08 instead of 50 hours. You need to multiply by 24 first, or use the HOUR and MINUTE functions. The next section covers the exact formulas.
- Tracking overtime by pay period instead of by workweek. The FLSA counts overtime per workweek, period. If someone works 38 hours in Week 1 and 42 in Week 2, you owe 2 hours of overtime for Week 2. The 80-hour combined total doesn't cancel it. This is one of the most common compliance gaps in small business payroll, and it's exactly the kind of thing a WHD audit catches first.
Excel Time Formulas for Payroll
The trap hidden in how Excel stores time
Excel and Google Sheets don't store time the way most people expect. Under the hood, 12:00 PM is 0.5 and 6:00 AM is 0.25, because both apps treat time as a fraction of a 24-hour day. It looks correct on screen. But once you try to do payroll math on it, the trouble starts. You can't just SUM a column of time cells and use the result as hours. You have to account for that 24-hour denominator first.
Formula 1 — Convert an Excel time value (HH:MM) to decimal hours:
=(HOUR(A2)*60+MINUTE(A2))/60This pulls the hour and minute components out separately, converts both to minutes, then divides by 60. It's the safest option when a cell is formatted as a time value in Excel, and it works even if someone's entered time in an unexpected way.
Formula 2 — One-step conversion by multiplying by 24:
=A2*24Since Excel stores time as a fraction of a full day, multiplying by 24 gives you hours. Watch this: format the result cell as a Number, not as Time, or Excel will display your decimal as a clock time again. Use the [h]:mm format only if you want the output back in HH:MM format.
Formula 3 — Convert a text string like "7:45" to decimal hours:
=LEFT(A2,FIND(":",A2)-1)+MID(A2,FIND(":",A2)+1,2)/60When someone types time as plain text (you can tell because it's left-aligned in the cell rather than right-aligned), Excel doesn't treat it as time at all. This formula uses LEFT to pull the hours, MID to pull the minutes, divides minutes by 60, and adds them together. The result is always a plain number ready to multiply against a wage rate.
Go Deeper on Excel Time Formulas
For a complete walkthrough of Excel time functions including overtime logic, SUMIF for multiple employees, and dynamic timesheet templates, see our dedicated guide: Excel Time-to-Decimal Formula Guide →
When to Use Payroll Software Instead of a Spreadsheet
For fewer than five or six employees with predictable schedules, a well-built spreadsheet works fine. The formula isn't complicated. Double-check each run, and you'll catch errors before they stack up. And it costs nothing beyond your time.
Scale past that point, though, and the formula stays simple while everything around it doesn't. Overtime per workweek. Multiple pay rates for the same person. PTO accruals. Shift differentials. Employees in different states with different rules. Each run turns into a checklist where one miss can mean a wage complaint or a back-pay obligation months down the line. Payroll software handles the decimal conversion, applies rounding consistently, flags overtime in real time, and connects directly to tax filing. Most businesses find it pays for itself in admin hours saved somewhere between five and ten employees.
Three options worth knowing, at different price points:
Affiliate Disclosure
The tools below include affiliate links. If you sign up through our links, we may earn a commission at no extra cost to you. Our recommendations are based on editorial merit. See full disclosure.
Questions Worth Answering
Complete Minutes-to-Decimal Conversion Chart (0-59 Minutes)
Look up any minute value without doing the math. All values are minutes divided by 60, rounded to four decimal places.
| Min | Decimal | Min | Decimal | Min | Decimal | Min | Decimal |
|---|
Formula used: minutes ÷ 60, rounded to 4 decimal places. Multiply by 60 to convert back to minutes.
Want to Skip the Math Entirely?
The free calculator handles individual entries, full weekly timesheets, and pay estimates. No signup, no spreadsheet setup required.
Open the Free Calculator