Understanding the hours to decimal converter — concept and principle
This converter turns time worked in hours and minutes into decimal hours, works out pay at an hourly rate, and turns decimal hours back into hours and minutes. It is used for timesheets, payroll, invoicing by the hour and project tracking.
How it is calculated
- Decimal hours = hours + minutes ÷ 60 + seconds ÷ 3,600.
- Total minutes = decimal hours × 60.
- Nearest quarter hour = round(seconds ÷ 900) ÷ 4.
- Pay = decimal hours × hourly rate.
- Reverse: the whole number is the hours; the fraction × 60 gives the minutes (and the remaining fraction × 60 the seconds).
The principle
Clock time counts in base 60: 60 minutes make an hour. Payroll and spreadsheets work in base 10, so 45 minutes must be written as 45 ÷ 60 = 0.75 of an hour, not 0.45. Mixing the two is the most common timesheet error. Converting back simply reverses the division. Some employers round to the nearest quarter hour or tenth of an hour; US federal rules allow such rounding only if, over time, it does not consistently work against the employee.
Worked example
Default inputs: 7:45 worked, rate $18, and 7.6 decimal hours to convert back.
- 7:45 = 7 + 45 ÷ 60 = 7.75 hours.
- Total minutes = 7.75 × 60 = 465; nearest quarter hour = 7.75.
- Pay = 7.75 × 18 = $139.50.
- 7.6 hours = 7 h + 0.6 × 60 = 36 min = 7:36:00, or 456 minutes.
| Time worked (h:mm or h:mm:ss) | Decimal hours |
|---|---|
| 1.75 | 1.75 |
| 3.5 | 3.5 |
| 5.25 | 5.25 |
| 7 | 7 |
| 8.75 | 8.75 |
| 10.5 | 10.5 |
| 14 | 14 |
How to read the result
Use the decimal figure when multiplying by a rate or adding hours in a spreadsheet, and the h:mm figure when reading a clock. Check that totals for a week add up in the same format. Common conversions: 15 min = 0.25 h, 20 min = 0.33 h, 30 min = 0.5 h, 40 min = 0.67 h.
Common mistakes
- Writing 7:45 as 7.45 hours.
- Reading 7.6 hours as 7 hours 6 minutes.
- Rounding each day separately and adding the rounded values.
- Forgetting unpaid breaks before converting.
Frequently asked questions
How do I convert 7 hours 45 minutes to decimal?
Divide the minutes by 60: 7 + 45/60 = 7.75 hours.
What is 0.6 of an hour in minutes?
0.6 × 60 = 36 minutes.
Can my employer round my hours?
In the US, rounding to 5, 6 or 15 minutes is allowed only if it averages out fairly over time.
Sources: BIPM, The International System of Units (SI Brochure), 9th ed., Table 8 (1 h = 60 min = 3,600 s) · US Code of Federal Regulations, 29 CFR 785.48(b) (rounding of recorded working time)