Quick answer: Keep the whole number as the hours, then multiply the decimal part by 60 to get the minutes. 8.75 hours = 8 hours 45 minutes, 8.25 hours = 8 hours 15 minutes and 2.5 hours = 2 hours 30 minutes.
Common decimal hours as clock time
The decimal values people convert most, with the hours-and-minutes form and the H:MM form.
| Decimal | Hours and minutes | H:MM |
|---|---|---|
| 1.25 hours | 1 h 15 min | 1:15 |
| 2.5 hours | 2 h 30 min | 2:30 |
| 3.75 hours | 3 h 45 min | 3:45 |
| 4.5 hours | 4 h 30 min | 4:30 |
| 5.25 hours | 5 h 15 min | 5:15 |
| 6.25 hours | 6 h 15 min | 6:15 |
| 6.5 hours | 6 h 30 min | 6:30 |
| 7.5 hours | 7 h 30 min | 7:30 |
| 7.75 hours | 7 h 45 min | 7:45 |
| 8.25 hours | 8 h 15 min | 8:15 |
| 8.5 hours | 8 h 30 min | 8:30 |
| 8.75 hours | 8 h 45 min | 8:45 |
The decimal to time formula
minutes = (decimal hours − whole hours) × 60The whole number stays as hours. The fraction becomes minutes.- Separate the whole number. From 7.75 the hours are 7.
- Take the decimal part. 0.75 is left after the 7.
- Multiply by 60. 0.75 × 60 = 45 minutes.
- Combine. 7.75 hours = 7 hours 45 minutes.
For seconds, multiply any leftover decimal minutes by 60 again. 1.21 hours is 1 hour and 0.21 × 60 = 12.6 minutes, then 0.6 × 60 = 36 seconds, giving 1:12:36.
Decimal hours to time chart
Quarter hours are worth memorising: 0.25 = 15 minutes, 0.50 = 30 minutes, 0.75 = 45 minutes. Every 0.1 of an hour is 6 minutes.
| Decimal | H:MM | Decimal | H:MM |
|---|---|---|---|
| 0.10 | 0:06 | 0.60 | 0:36 |
| 0.20 | 0:12 | 0.70 | 0:42 |
| 0.25 | 0:15 | 0.75 | 0:45 |
| 0.30 | 0:18 | 0.80 | 0:48 |
| 0.40 | 0:24 | 0.90 | 0:54 |
| 0.50 | 0:30 | 1.00 | 1:00 |
| 1.25 | 1:15 | 6.50 | 6:30 |
| 2.50 | 2:30 | 7.75 | 7:45 |
| 3.75 | 3:45 | 8.25 | 8:15 |
| 4.33 | 4:20 | 8.50 | 8:30 |
Worked examples
A payroll total: 8.5 hours
- Whole hours: 8
- Decimal part: 0.5 × 60 = 30 minutes
Result: 8 hours 30 minutes
A repeating decimal: 4.33 hours
- Whole hours: 4
- Decimal part: 0.33 × 60 = 19.8 minutes
- 0.3333… is exactly 20 minutes, so round to 20
Result: about 4 hours 20 minutes
With seconds: 1.21 hours
- Whole hours: 1
- 0.21 × 60 = 12.6 minutes, so 12 minutes
- 0.6 × 60 = 36 seconds
Result: 1:12:36
Convert decimal to time in Excel or Google Sheets
Spreadsheets store time as a fraction of a day, so divide decimal hours by 24 and format the cell as time.
// Decimal hours in A1 as a time value
=A1/24
// then format the cell as h:mm or h:mm:ss
// Readable text such as 7h 45m
=INT(A1)&"h "&ROUND((A1-INT(A1))*60,0)&"m" Who uses decimal to time conversion
- Payroll teams reading decimal totals back as shift times.
- Employees checking a timesheet against their clock hours.
- Freelancers turning billed decimal hours into time actually spent.
- Schedulers building rosters from reports that store time as decimals.
Need to total a full week of shifts?
Open the Hours Worked CalculatorFrequently asked questions
How do I convert decimal hours to time?
Keep the whole number as hours, then multiply the decimal part by 60 to get the minutes. 7.75 hours is 7 hours and 0.75 × 60 = 45 minutes.
What is 8.75 hours in hours and minutes?
8 hours 45 minutes. The 8 stays as hours and 0.75 × 60 = 45 minutes.
How do I convert a decimal to minutes?
Multiply the decimal part by 60. 0.5 hours is 30 minutes and 0.75 hours is 45 minutes.
Can this converter show seconds?
Yes. Choose hours, minutes and seconds in the calculator and any leftover decimal minutes are multiplied by 60 again to give seconds.
Why does 4.33 hours not convert to a round number of minutes?
0.33 is a rounded version of 1/3. The exact value 0.3333… is exactly 20 minutes, so 4.33 hours is about 4 hours 20 minutes (19.8 minutes to be precise).
How do I convert decimal hours to time in Excel?
Divide by 24 and format the cell as Time: =A1/24 with the format h:mm. For readable text use =INT(A1)&”h “&ROUND((A1-INT(A1))*60,0)&”m”.
Related tools
Accuracy note: Results are rounded to the nearest minute unless you choose seconds. Repeating decimals such as 0.33 can differ slightly from your payroll system, so confirm final figures with your payroll provider where needed.
Content Lead, Anchor AI Tools, California, USA. Spotted an error? Email hello@anchoraitools.com and it will be checked and corrected. See our editorial standards.