Payroll minutes to decimal hours calculator
Enter worked hours and minutes. The calculator divides minutes by 60, adds the whole hours, and optionally multiplies the result by an hourly rate.
Hours and minutes to decimal
Decimal hours to hours and minutes
Quick rule
Minutes to decimal: divide by 60.
Decimal to minutes: multiply the decimal part by 60.
Complete payroll conversion chart: 1–60 minutes
The two-decimal column is convenient for display, while the three-decimal column preserves more precision. Use the precision required by your payroll or accounting system.
| Minutes | Decimal (2 places) | Decimal (3 places) | Common fraction |
|---|---|---|---|
| 1 | 0.02 | 0.017 | — |
| 2 | 0.03 | 0.033 | — |
| 3 | 0.05 | 0.050 | — |
| 4 | 0.07 | 0.067 | — |
| 5 | 0.08 | 0.083 | — |
| 6 | 0.10 | 0.100 | — |
| 7 | 0.12 | 0.117 | — |
| 8 | 0.13 | 0.133 | — |
| 9 | 0.15 | 0.150 | — |
| 10 | 0.17 | 0.167 | — |
| 11 | 0.18 | 0.183 | — |
| 12 | 0.20 | 0.200 | — |
| 13 | 0.22 | 0.217 | — |
| 14 | 0.23 | 0.233 | — |
| 15 | 0.25 | 0.250 | 1/4 hour |
| 16 | 0.27 | 0.267 | — |
| 17 | 0.28 | 0.283 | — |
| 18 | 0.30 | 0.300 | — |
| 19 | 0.32 | 0.317 | — |
| 20 | 0.33 | 0.333 | 1/3 hour |
| 21 | 0.35 | 0.350 | — |
| 22 | 0.37 | 0.367 | — |
| 23 | 0.38 | 0.383 | — |
| 24 | 0.40 | 0.400 | — |
| 25 | 0.42 | 0.417 | — |
| 26 | 0.43 | 0.433 | — |
| 27 | 0.45 | 0.450 | — |
| 28 | 0.47 | 0.467 | — |
| 29 | 0.48 | 0.483 | — |
| 30 | 0.50 | 0.500 | 1/2 hour |
| 31 | 0.52 | 0.517 | — |
| 32 | 0.53 | 0.533 | — |
| 33 | 0.55 | 0.550 | — |
| 34 | 0.57 | 0.567 | — |
| 35 | 0.58 | 0.583 | — |
| 36 | 0.60 | 0.600 | — |
| 37 | 0.62 | 0.617 | — |
| 38 | 0.63 | 0.633 | — |
| 39 | 0.65 | 0.650 | — |
| 40 | 0.67 | 0.667 | 2/3 hour |
| 41 | 0.68 | 0.683 | — |
| 42 | 0.70 | 0.700 | — |
| 43 | 0.72 | 0.717 | — |
| 44 | 0.73 | 0.733 | — |
| 45 | 0.75 | 0.750 | 3/4 hour |
| 46 | 0.77 | 0.767 | — |
| 47 | 0.78 | 0.783 | — |
| 48 | 0.80 | 0.800 | — |
| 49 | 0.82 | 0.817 | — |
| 50 | 0.83 | 0.833 | — |
| 51 | 0.85 | 0.850 | — |
| 52 | 0.87 | 0.867 | — |
| 53 | 0.88 | 0.883 | — |
| 54 | 0.90 | 0.900 | — |
| 55 | 0.92 | 0.917 | — |
| 56 | 0.93 | 0.933 | — |
| 57 | 0.95 | 0.950 | — |
| 58 | 0.97 | 0.967 | — |
| 59 | 0.98 | 0.983 | — |
| 60 | 1.00 | 1.000 | 1 hour |
How payroll time conversion works
Payroll systems normally store time as decimal hours because decimal values can be multiplied directly by an hourly rate. Minutes are based on 60, not 100, so the number after the decimal is not a minute count.
Decimal hours = whole hours + (minutes ÷ 60)
Example: 8 hours 45 minutes = 8 + (45 ÷ 60) = 8.75 hours.
Important: 1 hour 45 minutes is 1.75 hours, not 1.45 hours. Treating minutes as hundredths is one of the most common timesheet errors.
Worked payroll and billing examples
Shift with an unpaid break
An employee works from 8:15 AM to 5:00 PM with a 30-minute unpaid break. The elapsed time is 8 hours 45 minutes. After subtracting the break, paid time is 8 hours 15 minutes, or 8.25 decimal hours.
Weekly timesheet total
A total of 38 hours 40 minutes becomes 38 + (40 ÷ 60) = 38.6667 hours. Displayed to two decimal places, that is 38.67 hours.
Freelancer invoice
Two hours 20 minutes is 2.3333 hours. At $100 per hour, the unrounded calculation is 2.3333 × $100 = $233.33.
Overtime calculation
Convert the total worked time first, then separate regular and overtime hours according to the rules that apply to the worker. Keep sufficient decimal precision until the final pay calculation.
Excel and Google Sheets formulas
Use these formulas when preparing a timesheet or payroll worksheet:
- Minutes in A2 to decimal hours:
=A2/60 - Start time in A2 and end time in B2:
=(B2-A2)*24 - Subtract break minutes in C2:
=((B2-A2)*24)-(C2/60) - Gross pay when decimal hours are D2 and rate is E2:
=D2*E2
Format the result cell as a number rather than a clock time. For overnight shifts, use a formula or time-entry method that correctly handles the date change.
Conversion, display rounding, and payroll policies
Converting minutes to decimal hours is a mathematical operation. Rounding that number for display is different from changing recorded clock-in or clock-out times under a workplace policy. Use the actual recorded time and the precision your payroll system requires. If an organization applies a time-rounding policy, confirm that policy with the responsible payroll professional and applicable requirements.
Payroll hours conversion FAQs
Divide the number of minutes by 60. Add the result to any whole hours. For example, 20 minutes divided by 60 is 0.3333 hours.
Fifteen minutes is 0.25 decimal hours because 15 divided by 60 equals 0.25.
Forty-five minutes is 0.75 decimal hours.
Keep the whole hours and multiply the decimal part by 60. For example, 2.50 hours is 2 hours plus 0.50 × 60, or 2 hours 30 minutes.
No. One hour 45 minutes equals 1.75 decimal hours. A value of 1.45 decimal hours equals 1 hour 27 minutes.
Use the precision and timekeeping policy required by your payroll system or organization. Avoid rounding intermediate calculations unless the approved process specifically requires it.
Related time and work tools
Calculate exact shift lengths with the Hours Calculator. For international schedules, use the Remote Team Time Zone Planner or the Time Zone Converter.