Convert hours and minutes to decimal hours
Decimal hours = whole hours + minutes ÷ 60. For 7 hours 35 minutes, calculate 7 + 35 ÷ 60 = 7.583333… hours. The colon in 7:35 separates hours and minutes. A decimal point in 7.35 means 7 hours plus 0.35 of an hour, which is only 21 minutes.
For a value supplied entirely in minutes, divide the whole value by 60: 455 ÷ 60 = 7.583333… hours. For seconds, divide by 3,600. Decide which unit your source uses before importing a column.
Use a minutes-to-decimal conversion chart
| Minutes | Decimal hours | Example duration |
|---|---|---|
| 5 | 0.083333 | 8:05 = 8.083333 hours |
| 6 | 0.100000 | 8:06 = 8.10 hours |
| 10 | 0.166667 | 8:10 = 8.166667 hours |
| 12 | 0.200000 | 8:12 = 8.20 hours |
| 15 | 0.250000 | 8:15 = 8.25 hours |
| 20 | 0.333333 | 8:20 = 8.333333 hours |
| 30 | 0.500000 | 8:30 = 8.50 hours |
| 35 | 0.583333 | 8:35 = 8.583333 hours |
| 45 | 0.750000 | 8:45 = 8.75 hours |
| 48 | 0.800000 | 8:48 = 8.80 hours |
| 60 | 1.000000 | 8 hours + 60 minutes = 9 hours |
The calculator's complete minutes chart covers every minute from 0 to 59. Keep original durations when totaling; the displayed chart values are rounded representations.
Reconcile a three-shift timecard
Suppose the worked durations after unpaid breaks are 7:45, 8:20 and 6:55. Convert them to 465, 500 and 415 minutes. The control total is 1,380 minutes, or exactly 23 decimal hours.
The individual decimal values are 7.75, 8.333333… and 6.916666…. Keeping their precision reproduces 23. In this particular example, rounding each row to two decimals also totals 23, but that is not guaranteed. Three ten-minute rows illustrate the difference: 0.17 + 0.17 + 0.17 = 0.51 hours, whereas 30 original minutes is 0.50 hours.
Conversion and time-punch rounding are different operations. Keep the original entries and compare your arithmetic with the rounding step used by the receiving system. Use the timesheet rounding checker to compare row-rounded and total-rounded values.
Check a simple payroll amount
At an illustrative single rate of $24 per hour, 7:35 produces (7 + 35 ÷ 60) × 24 = $182.00. If you multiply a rounded value of 7.58 by $24, the result becomes $181.92. The eight-cent difference comes from rounding the duration before multiplying.
This example checks arithmetic only. The conversion does not decide which time is payable, whether premiums apply, or what rounding rule is required. For start and end times rather than existing durations, calculate the elapsed time and subtract the appropriate unpaid breaks in the work hours calculator first.
Convert Excel values without changing the unit
If A2 contains a numeric total of minutes, use =A2/60. If A2 contains a genuine Excel time duration, use =A2*24 and format the result as a number. Excel stores time as a fraction of a day, so the two formulas solve different input cases.
To turn decimal hours back into an Excel duration, use =A2/24. For totals that exceed one day, display the result with [h]:mm so the hours do not wrap after 24. A text value that merely looks like a time must be converted to a numeric time value before applying these formulas.
See Microsoft's time arithmetic examples and formatting for totals above 24 hours. For a step-by-step sheet, use the Excel minutes-to-decimal guide.
Reverse-check a decimal and prepare an import
Take the fractional part of decimal hours and multiply it by 60. For 8.6, the fraction 0.6 becomes 36 minutes: 8:36. For 0.80 hours, the result is 48 minutes. For 0.10 hours, it is 6 minutes.
Before importing a batch, confirm the expected unit, row count, decimal separator and precision. Compare the source total with the exported total, investigate rejected rows and retain an unchanged source copy. A decimal number without a unit is not enough information to decide whether it represents hours, minutes or days.
Use the decimal hours calculator and bulk converter to convert your durations, then follow the payroll import checklist for the final reconciliation.