Complete reference chart — every minute from 1 to 60 converted to decimal format for payroll, timesheets, and billing.
| Minutes | Decimal | Fraction |
|---|
| Minutes | Decimal | Fraction |
|---|
Frequently used hour + minute combinations converted to decimal format.
Need a different value? Use our Hours to Decimal Calculator →
The formula is simple: divide the number of minutes by 60. The result is the decimal fraction of an hour.
| Minutes | Calculation | Decimal | Easy to Remember |
|---|---|---|---|
| 15 min | 15 ÷ 60 | 0.25 | ¼ of an hour |
| 30 min | 30 ÷ 60 | 0.50 | ½ of an hour |
| 45 min | 45 ÷ 60 | 0.75 | ¾ of an hour |
| 60 min | 60 ÷ 60 | 1.00 | Full hour |
To divide and convert standard minutes (e.g., 45 minutes in cell A1) to decimal hours in Microsoft Excel or Google Sheets, use this formula:
=A1/60
Tip: To convert an entire HH:MM string, format the target cell as General and use =A1*24.
When your timesheet shows 8h 45m and you need to enter it into payroll software that requires decimal hours, you look up 45 in this chart → 0.75 → enter 8.75 hours. No math needed.
This chart is also useful for billing clients, calculating contractor pay, verifying time clock exports, and any situation where you need to switch between clock time and decimal time quickly.
Many payroll systems round to the nearest 6 minutes (0.1 hour). This is commonly known as the 10th-of-an-hour method. The key 6-minute intervals are: 6 min = 0.10, 12 min = 0.20, 18 min = 0.30, 24 min = 0.40, 30 min = 0.50, 36 min = 0.60, 42 min = 0.70, 48 min = 0.80, 54 min = 0.90, 60 min = 1.00.
Common questions about converting minutes to decimal hours.
To convert minutes to decimal, divide the number of minutes by 60. For example, 45 minutes ÷ 60 = 0.75 decimal hours. If you have hours as well, simply keep the whole hours and add the decimal: 8 hours and 45 minutes becomes 8.75 decimal hours.
15 minutes is exactly 0.25 in decimal. This represents a quarter of an hour (15 ÷ 60 = 0.25). On a timesheet, 8 hours 15 minutes is recorded as 8.25 decimal hours.
30 minutes is exactly 0.50 in decimal. This represents half of an hour (30 ÷ 60 = 0.50). On a timesheet, 7 hours 30 minutes is recorded as 7.50 decimal hours.
45 minutes is exactly 0.75 in decimal. This represents three-quarters of an hour (45 ÷ 60 = 0.75). On a timesheet, 8 hours 45 minutes is recorded as 8.75 decimal hours.
Many payroll providers (like QuickBooks, ADP, and Gusto) use a 10th-of-an-hour rounding rule, which rounds work times to the nearest 6-minute increment (0.10 of an hour). For example, 6 minutes = 0.10, 12 minutes = 0.20, 18 minutes = 0.30, 24 minutes = 0.40, and so on. This simplifies timesheet calculations and matches the standard base-10 numerical system.
All the time conversion tools you need, completely free.
Convert hours and minutes to decimal format for payroll and timesheets.
Convert decimal hours back to hours and minutes format (HH:MM).
Convert any decimal time like 7.75 back to hours and minutes instantly.
Add multiple time entries and get total decimal hours for the week.
Calculate gross pay by multiplying decimal hours by your hourly rate.
Full reference chart — every minute from 1 to 60 in decimal format.
Calculate total hours worked between start/end times with break deduction.
Multiply hours, minutes, and seconds by any multiplier factor instantly.