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.
Convert total hours into standard calendar days or business workdays.
Estimate the cash payout value of your accrued, unused vacation days.
Calculate Paid Time Off (PTO) accruals per hour worked or per pay period.
Estimate game and file download times based on size and internet speed.
Convert simple fractions and mixed numbers to decimal format instantly.
Calculate calendar days, business days, and working hours between two dates.
Calculate overtime pay and estimate tax savings under tax-free policies.
Calculate daily regular, overtime (1.5x), and double-time (2.0x) pay.
Calculate your base pay or annual salary after a percentage or flat rate raise.
Calculate regular, overtime (1.5x), and double-time (2.0x) hourly wages.
Find out how standard and supplemental taxes impact your overtime take-home pay.
Proportion salaries by working hours, or calculate pro-rata rent for partial months.
Estimate the standard living wage and basic needs budget required in your cost tier.
Estimate travel payouts or tax deductions using standard annual IRS mileage rates.
Calculate standard reading and speaking times based on word count or pasted text.