Was this calculator helpful?
Sources & Methodology
Decimal → Time: Hours = FLOOR(decimal), Minutes = FLOOR((decimal - Hours) × 60), Seconds = ROUND(((decimal - Hours) × 60 - Minutes) × 60) Time → Decimal: Decimal Hours = Hours + (Minutes ÷ 60) + (Seconds ÷ 3600) Minutes → Decimal: Decimal Hours = Total Minutes ÷ 60 All arithmetic uses standard base-60 time conversion. No rounding is applied to intermediate steps to maximise accuracy.
Last reviewed: April 2026
Decimal to Time Conversion — Complete Guide
Decimal time is how most payroll software, invoicing systems, and spreadsheets represent hours worked. Instead of writing 2 hours 45 minutes as 2:45, decimal time expresses it as 2.75 hours. Converting between these two formats is a frequent need for freelancers, employees, HR professionals, and anyone who tracks time for billing or payroll purposes.
How to Convert Decimal Hours to Hours and Minutes
The conversion is straightforward: the whole number before the decimal point is your hours. Multiply the decimal portion by 60 to get minutes. If there are still remaining decimals after that, multiply by 60 again to get seconds.
Step 2: Minutes = decimal remainder × 60 (e.g. 0.75 × 60 = 45 minutes)
Step 3: Seconds = any remaining decimal × 60 (e.g. 0.0 × 60 = 0 seconds)
Example 1: 2.75 hours = 2 hours 45 minutes 0 seconds = 02:45:00
Example 2: 1.5 hours = 1 hour 30 minutes = 01:30:00
Example 3: 7.333 hours = 7 hours 20 minutes = 07:20:00
Complete Decimal Hours Reference Table
| Decimal Hours | Hours & Minutes | HH:MM:SS | Common Use |
|---|---|---|---|
| 0.25 | 0 hr 15 min | 00:15:00 | Quarter hour |
| 0.50 | 0 hr 30 min | 00:30:00 | Half hour |
| 0.75 | 0 hr 45 min | 00:45:00 | Three-quarter hour |
| 1.00 | 1 hr 0 min | 01:00:00 | Full hour |
| 1.25 | 1 hr 15 min | 01:15:00 | 1 hour + quarter |
| 1.50 | 1 hr 30 min | 01:30:00 | 1.5 hours |
| 1.75 | 1 hr 45 min | 01:45:00 | 1 hour + 45 min |
| 2.25 | 2 hr 15 min | 02:15:00 | 2.25 hours |
| 2.50 | 2 hr 30 min | 02:30:00 | 2.5 hours |
| 2.75 | 2 hr 45 min | 02:45:00 | 2.75 hours |
| 3.75 | 3 hr 45 min | 03:45:00 | 3.75 hours |
| 7.50 | 7 hr 30 min | 07:30:00 | 7.5 hour workday |
| 7.75 | 7 hr 45 min | 07:45:00 | 7.75 hours |
| 8.00 | 8 hr 0 min | 08:00:00 | Standard 8-hour day |
| 8.50 | 8 hr 30 min | 08:30:00 | 8.5 hours |
How to Convert Time to Decimal for Payroll
To convert HH:MM to decimal for payroll, divide the minutes by 60 and add to the hours. For example, 7 hours 45 minutes: 45 ÷ 60 = 0.75, so 7:45 = 7.75 decimal hours. Multiply 7.75 by your hourly rate to calculate gross pay. This is the format most payroll software, Excel, and accounting systems expect.
Decimal Time in Excel
Excel stores time values as decimal fractions of a 24-hour day. A value of 0.5 in a time-formatted cell represents noon (12:00). To work with decimal hours in Excel:
- Convert Excel time to decimal hours: Multiply the cell by 24. If A1 contains 7:30 (formatted as time), use =A1*24 to get 7.5 decimal hours.
- Convert decimal hours to Excel time: Divide by 24. If B1 contains 7.5, use =B1/24 and format the cell as Time to display 7:30.
- Sum hours correctly: Use the formula =SUM(range)*24 to get total decimal hours from a column of time values.
- Calculate pay in Excel: =SUM(time_range)*24*hourly_rate gives total gross pay directly.
Why Payroll Uses Decimal Time
Standard arithmetic only works cleanly with base-10 numbers. Time uses base-60 (60 seconds in a minute, 60 minutes in an hour), which creates problems when doing direct multiplication. If an employee worked 7 hours 45 minutes and earns $20/hour, you cannot directly multiply 7.45 by 20 — that gives $149, not the correct $155. Converting first to 7.75 decimal hours gives the correct answer: 7.75 × $20 = $155. This is why every payroll system converts HH:MM to decimal before any wage calculation.