Whether you're processing payroll, filling in a timesheet, or billing a client, converting hours and minutes to decimal format is one of the most common — and most confusing — calculations people face every week. This guide explains everything clearly, with examples you can follow step by step.
Quick Answer: Decimal Hours = Hours + (Minutes ÷ 60). For example, 2 hours 30 minutes = 2 + (30 ÷ 60) = 2.5 decimal hours.
Why Do We Use Decimal Hours?
Standard time uses a 60-minute system (HH:MM), but most payroll software, spreadsheets, and billing systems work better with decimal numbers. The reason is simple: you can't multiply 7:45 (hours:minutes) directly by a dollar amount, but you can multiply 7.75 × $20 = $155 easily.
Decimal hours are used everywhere — from QuickBooks and ADP payroll processing, to Excel timesheet formulas, to freelancer invoices.
The Formula for Hours to Decimal Conversion
Step-by-Step Examples
Example 1: Converting 2 hours 30 minutes
- Take the whole hours: 2
- Divide the minutes by 60: 30 ÷ 60 = 0.5
- Add them together: 2 + 0.5 = 2.5 decimal hours
Example 2: Converting 7 hours 45 minutes (common payroll example)
- Whole hours: 7
- Minutes: 45 ÷ 60 = 0.75
- Result: 7 + 0.75 = 7.75 decimal hours
- Pay calculation: 7.75 × $25/hr = $193.75
Example 3: Converting 1 hour 20 minutes
- Whole hours: 1
- Minutes: 20 ÷ 60 = 0.333... (rounds to 0.33)
- Result: 1 + 0.33 = 1.33 decimal hours
Common Hours to Decimal Conversions
| Time | Decimal Hours | Pay at $20/hr |
|---|---|---|
| 0:15 (15 minutes) | 0.25 | $5.00 |
| 0:30 (30 minutes) | 0.50 | $10.00 |
| 0:45 (45 minutes) | 0.75 | $15.00 |
| 1:00 (1 hour) | 1.00 | $20.00 |
| 1:30 | 1.50 | $30.00 |
| 7:30 | 7.50 | $150.00 |
| 7:45 | 7.75 | $155.00 |
| 8:00 | 8.00 | $160.00 |
How to Convert Hours to Decimal in Excel
If your time is in HH:MM format in a cell (say, A1), you can convert to decimal hours using these Excel formulas:
📊 Excel Formula: Hours to Decimals
The easiest way to convert a time cell (e.g. 7:45 inside Cell A1) into decimal hours (7.75) is to multiply the cell by 24:
=A1*24
Important: After entering this formula, Excel may try to automatically format the destination cell as Time. You must manually right-click the cell → Format Cells → Set to General or Number to see the correct decimal value.
What is Payroll Rounding?
Many companies use time rounding rules for payroll. The most common methods are:
- 6-minute rounding — Rounds to the nearest 0.1 hours (6 min = 0.1h, 12 min = 0.2h, etc.)
- 15-minute rounding — Rounds to nearest quarter hour (0.25h increments)
- 30-minute rounding — Rounds to nearest half hour
Our hours to decimal calculator includes all these rounding options, matching exactly what major payroll systems use.
Use Our Free Calculator
Instead of doing this math manually every time, use our free Hours to Decimal Calculator. It converts instantly, shows the step-by-step formula, and includes payroll rounding options. No signup, no ads blocking results, completely free.