Convert decimal hours to hours, minutes and seconds (HH:MM:SS) instantly. Also convert time back to decimal for payroll, timesheets, invoices and project tracking. Works both ways — fast and accurate.
✓Verified: ISO 8601 Time Standard & Standard Arithmetic — April 2026
⏱ Select Conversion Direction
hrs
e.g. 1.5, 2.25, 7.75, 8.0Enter a valid decimal number (e.g. 2.75).
h
Whole hours (e.g. 2)Enter valid hours (0 or more).
m
Minutes (0–59)Enter valid minutes (0–59).
s
Seconds (0–59), leave blank if noneEnter valid seconds (0–59).
min
e.g. 90 minutes = 1.5 hoursEnter a valid number of minutes.
Result
—
⚠️ Disclaimer: Results use standard base-60 time arithmetic. Always verify payroll calculations against your organisation’s time-rounding policy before processing wages.
Sources & Methodology
✓All conversions use standard base-60 arithmetic. Payroll decimal rounding follows U.S. Department of Labor Fair Labor Standards Act (FLSA) guidance. ISO 8601 HH:MM:SS format used for time output.
The FLSA permits employers to round employee time to the nearest 5 minutes, one-tenth, or one-quarter of an hour, provided rounding does not systematically undercount hours. Most payroll systems use quarter-hour increments (0.25 decimal hour = 15 minutes).
HH:MM:SS is the ISO 8601 time notation used in this calculator. Hours use 24-hour format. This format is standard in timesheets, scheduling software, and international business applications.
Excel stores time as fractions of a day. To convert Excel time to decimal hours, multiply the cell value by 24. To convert decimal hours back to Excel time, divide by 24. This calculator matches Excel’s time arithmetic exactly.
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.
Decimal to Time Formula
Step 1: Hours = whole number part of the decimal (e.g. 2 from 2.75) 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)
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.
💡 Payroll Shortcut: The four most common payroll decimals are: 15 min = 0.25, 30 min = 0.50, 45 min = 0.75, 60 min = 1.00. Most payroll systems round employee time to the nearest quarter-hour per U.S. Department of Labor FLSA guidance.
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.
Frequently Asked Questions
Multiply the decimal portion by 60 to get minutes. For 2.75 hours: whole number = 2 hours, 0.75 × 60 = 45 minutes, so 2.75 = 2 hours 45 minutes. In HH:MM:SS format: 02:45:00.
1.5 hours = 1 hour 30 minutes. The decimal 0.5 × 60 = 30 minutes. In HH:MM:SS format: 01:30:00. This is a common payroll decimal for a lunch break or half-hour overtime increment.
0.75 hours = 45 minutes. Multiply 0.75 by 60 to get 45. In HH:MM:SS format: 00:45:00. This is one of the most common payroll decimals, representing the three-quarter hour mark.
Divide the minutes by 60 to get the decimal portion, then add the hours. For 7 hours 45 minutes: 45 ÷ 60 = 0.75, so 7:45 = 7.75 decimal hours. Multiply 7.75 by your hourly rate to get gross pay.
Divide total minutes by 60. 90 minutes ÷ 60 = 1.5 hours. 45 minutes ÷ 60 = 0.75 hours. 30 minutes ÷ 60 = 0.5 hours. Use the Minutes to Decimal tab above for instant conversion.
2.25 hours = 2 hours 15 minutes. The decimal 0.25 × 60 = 15 minutes. In HH:MM format: 2:15. In HH:MM:SS: 02:15:00.
Payroll uses decimal time because standard multiplication only works with base-10 numbers. You cannot multiply 7:45 directly by an hourly rate. Converting 7:45 to 7.75 decimal hours first allows clean arithmetic: 7.75 × $20 = $155 correct gross pay.
If your decimal hours are in cell A1, divide by 24 and format the result as time: =A1/24 (then format cell as HH:MM). To convert in the other direction (time to decimal hours), use =A1*24. For payroll totals: =SUM(range)*24 gives total decimal hours.
3.75 hours = 3 hours 45 minutes. The decimal 0.75 × 60 = 45 minutes. In HH:MM:SS: 03:45:00. At $20/hour, 3.75 decimal hours = $75 gross pay.
0.5 hours = 30 minutes. Half an hour as a decimal is 0.5. Confirm with 0.5 × 60 = 30 minutes. In HH:MM:SS format: 00:30:00.
The four standard payroll quarter-hour decimals: 15 min = 0.25, 30 min = 0.50, 45 min = 0.75, 60 min = 1.00. Most payroll systems round to the nearest quarter-hour per U.S. DOL guidance. An 8-hour day = 8.0 decimal hours. A 37.5-hour week = 37.5 decimal hours.
1.25 hours = 1 hour 15 minutes. The decimal 0.25 × 60 = 15 minutes. In HH:MM:SS: 01:15:00. This is a common payroll increment for overtime tracking.