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.333 = 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:
- =HOUR(A1)+MINUTE(A1)/60 — Works when A1 contains a time value
- =A1*24 — Shortcut that works when A1 is formatted as Time
- =TIMEVALUE("2:30")*24 — Converts a text time string directly
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.