Decimal to Time Converter
Use this decimal to time converter to convert decimal hours into hours and minutes instantly for payroll, billing, spreadsheets, and time tracking.
Enter decimal hours or numeric hours such as 8.75 to convert decimal hours to time in hours and minutes.
Convert decimal hours to time by keeping the whole number as hours and multiplying the decimal part by 60 to calculate minutes.
Decimal to Time Formula
To convert decimal to time, keep the whole number as hours and multiply the decimal part by 60 to get minutes. This decimal to time formula works for payroll, spreadsheets, billing, and any decimal hours calculator workflow.
Hours = whole number
Minutes = decimal part × 60
8.75 = 8 hours + (0.75 × 60) = 45 minutes
8.75 in time
8 hours + 0.75 × 60 = 45 minutes.
08:45
5.50 in time
5 hours + 0.50 × 60 = 30 minutes.
05:30
7.25 in time
7 hours + 0.25 × 60 = 15 minutes.
07:15
Common Decimal to Time Conversions
Use these common decimal to time examples to quickly check hours and minutes without doing the math manually.
1.25 hours
1 hour 15 minutes
01:15
0.50 hours
0 hours 30 minutes
00:30
0.75 hours
0 hours 45 minutes
00:45
8.25 hours
8 hours 15 minutes
08:15
Decimal to Time in Excel and Google Sheets
You can convert decimal to time in Excel or Google Sheets by dividing decimal hours by 24 and then formatting the result as time. This is useful when you need hours and minutes instead of decimal hours in reports or timesheets.
How to convert decimal to time in Excel
If A1 contains 8.75, use this formula and format the cell as hh:mm.
Format the result cell as hh:mm or [h]:mm to display hours correctly.
How to convert decimal to time in Google Sheets
Use the same formula in Google Sheets, then apply a time format to display hours and minutes.
Decimal to Time FAQ
These quick answers cover the most common decimal to time converter questions.
How do I convert decimal to time?
Keep the whole number as hours, multiply the decimal part by 60, and use the result as minutes.
What is 8.75 in time?
8.75 hours equals 8 hours and 45 minutes, which is shown as 08:45.
What is 0.75 hours?
0.75 hours equals 45 minutes, which is shown as 00:45 in time format.
How do I convert decimal hours to hours and minutes?
Separate the whole hours first, then multiply the remaining decimal value by 60 to get minutes.
How do I convert decimal to time in Excel?
Divide the decimal hours by 24 with =A1/24, then format the result as a time value such as hh:mm or [h]:mm.
Related Time Conversion Tools
Explore related tools for decimal hours, minute conversions, spreadsheet formulas, and work time calculations.
Time to Decimal Converter
Convert hours and minutes into decimal hours for payroll and billing.
Minutes to Decimal Chart
Check minute-to-decimal values quickly with a ready-made reference table.
Excel Time Formula Guide
Use spreadsheet formulas to convert between decimal hours and time formats.
Time Card Calculator
Calculate daily and weekly work hours for timesheets and employee tracking.
Need the standard time to decimal converter too?
Go back to the main calculator to convert hours and minutes into decimal hours for payroll, billing, spreadsheets, and work tracking.
Back to Time to Decimal Converter