Decimal Hours to Hours and Minutes: Formula and Examples
Turn 7.75 back into 7:45, handle the 60-minute carry, and convert a whole column in Excel or Google Sheets.
Actualizado 2026-10-20
Esta guía está disponible en inglés por ahora; la traducción al español llegará pronto.
Pay stubs and payroll exports show decimal hours. People think in hours and minutes. Converting back is two steps.
The method
- The whole number is the hours.
- Multiply the decimal part by 60 and round to get minutes.
7.75 → 7 hours and 0.75 × 60 = 45 minutes → 7:45. 8.33 → 8 hours and 0.33 × 60 = 19.8 → 20 minutes → 8:20.
The carry rule
0.999 × 60 = 59.94, which rounds to 60. Sixty minutes is an hour, so 7.999 becomes 8:00, not 7:60. Any converter that prints 7:60 has skipped this step. Ours checks for 60 and carries.
Why 8.33 gives 8:20 and not 8:19.8
Two-decimal payroll values are already rounded, so 8.33 could have been anything from 8.325 to 8.335 (8:19.5 to 8:20.1). Rounding minutes to the nearest whole minute recovers the original 8:20 in practice. For exact round trips keep four decimals or store minutes.
Table of common values
| 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.33 | 0:20 | 0.80 | 0:48 |
| 0.40 | 0:24 | 0.90 | 0:54 |
| 0.50 | 0:30 | 1.00 | 1:00 |
In Excel and Google Sheets
Decimal hours in A1. Divide by 24 to get a time value and format it:
=A1/24Apply the custom format [h]:mm (Excel) or Format > Number > Duration (Sheets). The brackets let totals exceed 24 hours. To get text instead: =INT(A1)&":"&TEXT(ROUND((A1-INT(A1))*60,0),"00"), though that version does not carry at 60; use =TEXT(A1/24,"[h]:mm") which does.
Minutes only
Decimal hours to total minutes: multiply by 60. 7.75 × 60 = 465 minutes. Minutes to decimal hours: divide by 60.
Negative values
A negative decimal, such as −1.5 hours of adjustment, converts the same way with the sign kept: −1 hour and 30 minutes, written −1:30. Spreadsheets cannot display negative times in the default 1900 date system; use =TEXT(ABS(A1)/24,"[h]:mm") and prepend the sign, or switch to the 1904 date system in Excel options.
Converting a payroll export
A payroll export usually has one decimal column per employee per day. Add a column with =TEXT(A1/24,"[h]:mm") and fill down; the result is text suitable for printing on a timesheet. Totals should still be computed on the decimal column, because text cannot be summed.
Why payroll systems keep decimals
Multiplication: 7.75 hours × $18.50 = $143.38 directly. In H:MM you would convert first anyway. Decimals also sort and total correctly in any database. Minutes-based storage (465 minutes) is even safer and is what our engine uses internally; it converts to decimal or H:MM only when displaying.
Precision trap
Two-decimal payroll hours lose up to 18 seconds per entry (0.005 hours). Across 250 workdays that is up to 75 minutes of accumulated rounding, although in practice errors in both directions mostly cancel. If an employer rounds hours to two decimals and then rounds pay to cents, the employee can be short by a few cents a week. Tracking in whole minutes and rounding money once avoids this entirely.
Frequently asked
What is 0.1 hours in minutes? 6 minutes. 0.5 is 30, 0.9 is 54.
What is 1.5 hours? 1 hour 30 minutes.
Is 7.5 hours 7 hours 50 minutes? No. 7.5 is seven and a half hours, or 7:30. The decimal part is a fraction of an hour, not a count of minutes.
How do I show 36.25 hours as a time? Divide by 24 and format as [h]:mm: 36:15. Without the brackets Excel wraps at 24 and shows 12:15.
What is 2.33 hours? 2 hours 20 minutes (0.33 × 60 = 19.8, rounded to 20).
How do I convert 100 minutes? Divide by 60: 1.667 hours, or 1:40.
What is 5.75 hours in hours and minutes? 5 hours 45 minutes. The 0.75 is three quarters of an hour.
Does the converter handle values over 24? Yes. 36.5 becomes 36:30; there is no wrap at a day because these are durations, not clock times.