Timesheet Hours to Decimal Converter
Convert timesheet hours and minutes into decimal hours for payroll. Enter time as hours and minutes — get the exact decimal payroll systems expect, calculate gross pay in the same step, and use the standard rounding chart below.
Quick answer: Decimal hours = hours + (minutes ÷ 60). A timesheet showing 38 hours 20 minutes converts to 38 + (20 ÷ 60) = 38.33 decimal hours. Entering "38.20" instead would underpay 8 minutes — minutes must be divided by 60, never written after the decimal point.
Timesheet to Decimal Formula
Decimal Hours = Hours + (Minutes ÷ 60)
38 hours 20 minutes = 38 + (20 ÷ 60) = 38.33 hours. Multiply by the hourly rate for gross pay: 38.33 × $20 = $766.67. This single division is the entire secret of payroll time conversion — everything else is rounding policy.
Minutes to Decimal Conversion Chart
| Minutes | Decimal | Minutes | Decimal | Minutes | Decimal |
|---|---|---|---|---|---|
| 1 | 0.02 | 21 | 0.35 | 41 | 0.68 |
| 5 | 0.08 | 25 | 0.42 | 45 | 0.75 |
| 10 | 0.17 | 30 | 0.50 | 50 | 0.83 |
| 15 | 0.25 | 35 | 0.58 | 55 | 0.92 |
| 20 | 0.33 | 40 | 0.67 | 60 | 1.00 |
Worked Examples
Example 1 — weekly payroll. A timesheet totals 41 hours 50 minutes: 41 + (50 ÷ 60) = 41.83 hours. At $18/hour with overtime beyond 40: (40 × 18) + (1.83 × 27) = $720 + $49.50 = $769.50 gross.
Example 2 — the classic underpayment. Payroll clerk types "38.20" for 38h 20m. System pays 38.2 hours = 38h 12m — 8 minutes short. At $25/hour across 50 employees weekly, that one habit silently underpays about $8,600/year.
Example 3 — billing a client. A consultant's tracker shows 12:35 for the week: 12 + 35/60 = 12.58 hours × $95 = $1,195.10 on the invoice.
Why Payroll Requires Decimals
Wage math is multiplication, and multiplication needs base-10 numbers. H:MM format is base-60 — useful for clocks, useless against a rate. Every payroll platform (ADP, Gusto, Paychex, QuickBooks) stores time as decimal hours internally and most reject H:MM in imports. Timesheets get converted exactly once, at entry — which is why the person doing that conversion (often you) needs this page's chart taped to the monitor.
Payroll Rounding: The 7-Minute Rule and Its Cousins
US employers may lawfully round punches — most commonly to the nearest quarter hour: minutes 1–7 round down, 8–14 round up (the "7-minute rule"). Alternatives: nearest tenth (6-minute blocks) or nearest 5 minutes. Two legal constraints: rounding must be neutral or favor the employee over time, and California courts have sharply restricted rounding where exact records exist. Practical advice: if your workplace rounds, compare a month of your raw punches against paid hours — always-downward rounding is a recoverable wage violation.
Converting a Full Timesheet Correctly
- Total each day first (end − start − unpaid breaks) with the work hours calculator.
- Sum days in H:MM, carrying 60 minutes into hours (e.g. 7:50 + 8:20 = 16:10).
- Convert the weekly total once — converting each day separately then summing rounded decimals can drift by a few hundredths; one conversion of the total avoids it.
- Apply overtime split beyond 40 hours through the overtime pay calculator, or let the time card calculator do all four steps at once.
Decimal Entry Conventions in Popular Systems
| System | Expected format | Gotcha |
|---|---|---|
| ADP / Paychex imports | Decimal (38.33) | Rejects 38:20 in CSV |
| QuickBooks Time | Either; stores decimal | Export setting controls format |
| Excel timesheets | Time cells; ×24 for decimal | Cell must be re-formatted as Number |
| Government forms (certified payroll) | Usually decimal, 2 places | Use 0.33/0.67 for 20/40 min |
Freelancers: Decimal Hours on Invoices
Bill in decimals and say so in your terms ("time billed in decimal hours, 6-minute increments") — it reads professionally and prevents disputes about what 3:50 means. Six-minute (0.1 hour) increments are the accounting-and-legal standard; quarter-hour minimums are common but increasingly challenged by clients. Whatever increment you choose, apply it consistently and keep raw logs. Need the reverse direction to sanity-check a payslip? Use the decimal hours to time converter.
Frequently Asked Questions
What is 38 hours and 20 minutes in decimal?
38.33 hours. Divide the 20 minutes by 60 (= 0.333) and add to 38.
Is 45 minutes 0.45 or 0.75?
0.75. Decimals are fractions of a 60-minute hour, so 45 ÷ 60 = 0.75. Writing minutes directly after the decimal point is the classic payroll error.
How do I convert timesheet minutes to decimal for payroll?
Divide minutes by 60 and add to whole hours: 8h 25m = 8 + 25/60 = 8.42. Then multiply by the pay rate.
What is the 7-minute rule in payroll?
With quarter-hour rounding, punches 1–7 minutes past a quarter round down and 8–14 round up. Rounding must be neutral over time to stay legal under the FLSA.
How do payroll systems round timesheet minutes?
Most round to the nearest quarter hour (15 min) or tenth of an hour (6 min). California strongly limits rounding where exact electronic records exist.
How do I convert decimal hours back to minutes?
Multiply the decimal part by 60. For 38.33 hours: 0.33 × 60 ≈ 20 minutes, so 38 hours 20 minutes.
Should I convert each day or the weekly total?
Convert the weekly H:MM total once. Converting rounded daily decimals and summing them can drift by a few hundredths of an hour.
What increment should freelancers bill in?
Six-minute (0.1 hour) increments are the professional standard. State the increment in your engagement terms and keep raw time logs to back invoices.
Why does my paycheck differ a cent from my own math?
Repeating decimals (20 and 40 minutes) round to 0.33/0.67, and systems compute at different precision. One-cent differences from rounding are normal and lawful.
✓ Formula verified • Last updated: July 10, 2026