Convert decimal hours back to hours and minutes (HH:MM) format instantly — free, accurate, no signup required.
Examples: 7.5 = 7:30 · 7.75 = 7:45 · 2.25 = 2:15 · 1.5 = 1:30
Need the full version? Visit our main Hours to Decimal Calculator →
Decimal hours come from payroll systems, timesheets, and spreadsheets. Converting them back to the familiar HH:MM format is quick once you know the formula.
To convert decimal hours (e.g., 7.75 in cell A1) to standard HH:MM time format in Microsoft Excel or Google Sheets, use this simple formula:
=A1/24
Formatting Required: After applying this formula, you must format the cell as Time. Right-click the cell → Format Cells → Time → Choose 37:30:55 or enter custom format [h]:mm.
The single most common mistake when converting timesheets manually is assuming the decimal part represents raw minutes. Review the correct calculations below to prevent costly payroll errors:
| Decimal Value | The Common Mistake | The Correct Conversion |
|---|---|---|
| 7.10 hours | 7 hours 10 mins | 7 hours 6 mins |
| 7.40 hours | 7 hours 40 mins | 7 hours 24 mins |
| 7.50 hours | 7 hours 50 mins | 7 hours 30 mins |
| 7.60 hours | 7 hours 60 mins | 7 hours 36 mins |
| 7.80 hours | 7 hours 80 mins | 7 hours 48 mins |
| Decimal Hours | Calculation | Hours : Minutes |
|---|---|---|
| 0.25 | 0.25 × 60 = 15 min | 0:15 |
| 0.50 | 0.50 × 60 = 30 min | 0:30 |
| 0.75 | 0.75 × 60 = 45 min | 0:45 |
| 1.25 | 1h + 0.25 × 60 = 15 min | 1:15 |
| 1.50 | 1h + 0.50 × 60 = 30 min | 1:30 |
| 2.75 | 2h + 0.75 × 60 = 45 min | 2:45 |
| 7.50 | 7h + 0.50 × 60 = 30 min | 7:30 |
| 7.75 | 7h + 0.75 × 60 = 45 min | 7:45 |
| 8.33 | 8h + 0.33 × 60 ≈ 20 min | 8:20 |
You received a payroll report showing 7.75 hours but need to enter it into a time clock system that requires 7:45 format. Or your project management tool exports decimal hours and you need to report them in standard time format to a client.
Other common scenarios include reading Excel timesheet exports, verifying payroll calculations, converting billed hours for invoices, and cross-referencing time tracking apps with manual records.
There are several situations where you need the standard time format instead of decimal.
Most physical time clocks and scheduling software require HH:MM input. Convert your decimal payroll exports back to clock time for entry.
Clients often prefer seeing "7 hours 45 minutes" on invoices rather than "7.75 hours." Convert decimal hours to readable time format.
Cross-check your pay stub. If it shows 40.5 hours, convert to 40h 30m to verify it matches your actual time clock records.
Common questions about converting decimal hours to HH:MM format.
7.75 hours is exactly 7 hours and 45 minutes. The whole number (7) represents the hours. The decimal part (0.75) multiplied by 60 gives the minutes (0.75 × 60 = 45).
Take the whole number as hours, then multiply the remaining decimal part by 60 to find the minutes. For example, to convert 2.5 hours: keep 2 hours, and multiply 0.5 by 60 (0.5 × 60 = 30), resulting in 2 hours and 30 minutes.
7.6 hours is 7 hours and 36 minutes, not 7 hours and 60 minutes or 7:06. The calculation is: 0.6 × 60 = 36 minutes. This is a very common error in payroll data entry.
8.8 hours is 8 hours and 48 minutes. Calculated as: 8 hours + (0.8 × 60) = 8 hours and 48 minutes.
1.5 hours is 90 minutes in total, which equals 1 hour and 30 minutes. Calculated as 1.5 × 60 = 90 minutes.
0.75 hours is 45 minutes. Calculated as: 0.75 × 60 = 45 minutes.
2.25 hours is 2 hours and 15 minutes. The whole hours are 2, and the decimal 0.25 × 60 = 15 minutes.
Payroll systems (like QuickBooks, Gusto, or ADP) process hours in decimal form because it simplifies financial arithmetic. For example, multiplying 38.75 hours by $20/hr is a simple math problem ($775.00). Multiplying 38 hours and 45 minutes by $20/hr requires converting the minutes first, making manual calculations prone to error.
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.