The formula
Decimal hours = minutes ÷ 60
For a value with both hours and minutes, keep the whole hours and add the minute fraction:
Total decimal hours = whole hours + (minutes ÷ 60)
Step-by-step
- 1
Separate hours and minutes
Take a value like 7h 24m and split it into 7 hours and 24 minutes. - 2
Divide minutes by 60
24 ÷ 60 = 0.40. That is the minute portion in decimal form. - 3
Add to whole hours
7 + 0.40 = 7.40 decimal hours. - 4
Round to your payroll standard
Most systems use two decimals. 7.40 stays 7.40. A value like 7.4167 would round to 7.42.
Reference chart: minutes to decimal hours
| Minutes | Decimal | Minutes | Decimal |
|---|---|---|---|
| 5 | 0.08 | 35 | 0.58 |
| 10 | 0.17 | 40 | 0.67 |
| 15 | 0.25 | 45 | 0.75 |
| 20 | 0.33 | 50 | 0.83 |
| 25 | 0.42 | 55 | 0.92 |
| 30 | 0.50 | 60 | 1.00 |
Worked example
An employee worked these hours over four days: 8h 15m, 7h 45m, 9h 30m, 8h 0m. Convert each to decimal:
- 8h 15m → 8 + (15 ÷ 60) = 8.25
- 7h 45m → 7 + (45 ÷ 60) = 7.75
- 9h 30m → 9 + (30 ÷ 60) = 9.50
- 8h 0m → 8.00
Total: 33.50 decimal hours. At $24/hour: 33.50 × $24 = $804.00 gross pay.
Common conversion mistakes
- Treating minutes as cents. 8h 30m is not 8.30 decimal hours, it is 8.50.
- Rounding too early. Round at the end, not after each entry.
- Mixing formats. Pick one format per timesheet, either hours-and-minutes or decimal, and convert at the end.
- Forgetting to deduct breaks. Convert paid time, not gross shift time.
Why payroll insists on decimal hours
Pay rates are decimal numbers, not base-60 numbers. Multiplying base-60 minutes by a decimal rate forces a conversion somewhere. Doing that conversion before the multiplication keeps payroll math transparent and auditable. It also avoids surprises when totals are rolled up across a week or pay period.
Manual vs automated conversion
If your time clock already exports decimal hours, the conversion has been done for you. Trust the export and only verify the totals. If you process timesheets by hand or pull data from a spreadsheet that shows hours and minutes, do the conversion in one place: a single column dedicated to decimals. Avoid sprinkling conversions through formulas because mistakes are hard to track down later.
Spreadsheet approach
In Excel or Google Sheets, the cleanest formula is HOUR(cell) + MINUTE(cell)/60. This works whether the cell is formatted as duration or as a time value. For a column of hours-and-minutes inputs, copy the formula down and the total will be correct. Set the result cell format to "Number" with two decimal places so the output reads like a payroll value, not a time.
Worked example: a full week
An employee logs these shifts: Mon 8h 12m, Tue 7h 48m, Wed 9h 6m, Thu 8h 0m, Fri 7h 24m. Convert each:
- 8h 12m → 8 + 12/60 = 8.20
- 7h 48m → 7 + 48/60 = 7.80
- 9h 6m → 9 + 6/60 = 9.10
- 8h 0m → 8.00
- 7h 24m → 7 + 24/60 = 7.40
Weekly total: 40.50 decimal hours. At $26/hour that is 40 × $26 + 0.50 × $39 = $1,040 + $19.50 = $1,059.50. The 0.50 above 40 triggers overtime at 1.5× because hours worked exceed the federal weekly threshold.
What rounding to pick
Two decimal places are the U.S. payroll standard for paycheck math. Four decimals are common in larger systems where rolled-up totals must reconcile precisely. Whichever you pick, use the same precision across the entire pay period. Mid-period rounding changes are the most common source of "off by a few cents" complaints from employees who reconcile their own time.
Important note
Decimal hour rounding rules can vary by payroll provider. Confirm your employer's rounding standard before submitting timesheets.