Understanding Decimal Time, How to Convert Work Hours for Payroll

Ever looked at a pay stub and noticed your hours listed as 38.75 instead of 38:45? That’s decimal time, and if it’s ever felt confusing, you’re not alone. Payroll systems don’t work in hours and minutes the way a clock does. They work in hours and decimal fractions, and knowing how that conversion works is what lets you verify every paycheck with confidence.

The good news: there’s really only one formula. Once you have it, every conversion is the same, no exceptions.

What Is Decimal Time?

Decimal time is just a way of expressing work hours as a single number rather than two separate values for hours and minutes.

Your clock runs on a base-60 system, 60 minutes per hour, 60 seconds per minute. Decimal time converts the minutes portion into a fraction of an hour using base-10 math, which is the system every calculator, spreadsheet, and payroll program runs on.

Here’s what that looks like in practice: 8 hours and 45 minutes (written as 8:45) becomes 8.75 in decimal time. The 8 stays the same. The 45 minutes converts to 0.75 because 45 ÷ 60 = 0.75. That’s the whole concept, one formula, applied to the minutes.

Why Payroll Uses Decimal Time

Payroll systems can’t multiply hours and minutes directly. You can’t take 8:45 and multiply it by $18.00 per hour in a standard formula, the math breaks down because minutes and decimals run on different scales.

Decimal time fixes this. Once 8:45 becomes 8.75, the pay calculation is simple:

8.75 hours × $18.00 = $157.50

Without that conversion, you’d need extra steps, and those extra steps are exactly where payroll errors tend to creep in.

Most payroll software, including QuickBooks, ADP, Gusto, and Paychex, processes time in decimal format. This is also why timecard calculators show two columns: hh:mm for easy reading, and decimal for payroll submission.

The One Formula You Need

To convert any number of minutes to a decimal fraction of an hour, divide the minutes by 60. Then add that decimal to the whole hours.

minutes ÷ 60 = decimal fraction

whole hours + decimal fraction = decimal time

Example 1: 7 hours and 20 minutes → 20 ÷ 60 = 0.333 → 7 + 0.333 = 7.33 hours

Example 2: 9 hours and 45 minutes → 45 ÷ 60 = 0.75 → 9 + 0.75 = 9.75 hours

Every single conversion follows the same two steps.

Complete Minutes to Decimal Conversion Chart

This chart covers all 60 minutes and their exact decimal equivalents. Bookmark it or print it — it comes up every payroll cycle.

Converting in Reverse — Decimal Back to Minutes

Sometimes you need to go the other direction — turning a decimal total back into hours and minutes to cross-check what you’re seeing on a pay stub.

decimal fraction × 60 = minutes

Example 1: Timecard shows 8.33 hours → 0.33 × 60 = 19.8 → rounds to 20 minutes → 8 hours and 20 minutes.

Example 2: Weekly total shows 38.75 hours → 0.75 × 60 = 45 minutes → 38 hours and 45 minutes.

The Most Common Decimal Conversion Mistakes

Mistake 1 — Writing Minutes Directly as Decimals

This is the most common error, and also the most damaging. Someone converts 45 minutes and writes .45 instead of doing the division. It feels intuitive because the numbers look similar, but they’re completely different values.

45 ÷ 60 = 0.75, not 0.45.

The difference between 8.45 and 8.75 is 18 minutes of pay per shift. At $18/hour, that’s $5.40 per day, $27 per week, and over $1,400 per year for a single employee.

The rule: always divide by 60. Never write minutes directly as a decimal.

Mistake 2 — Adding Clock Time Without Converting First

Adding hours and minutes without converting to decimal first produces wrong totals because of base-60 math.

Wrong way: 7:45 + 6:30 = 13:75. That’s not a valid time, 75 minutes is 1 hour and 15 minutes, so the actual answer is 14:15, which is 14.25 decimal hours, not 14.75.

Right way: 7.75 + 6.50 = 14.25 decimal hours → 0.25 × 60 = 15 minutes → 14 hours and 15 minutes. Correct.

Mistake 3 — Not Deducting Unpaid Meal Breaks

A 30-minute unpaid lunch break is not work time. Under federal regulations (29 CFR 785.18 and 785.19), unpaid meal breaks of 30 minutes or more should be deducted when the employee is fully relieved from duties. Short paid breaks under 20 minutes must be included in work time.

If an employee works 9:00 AM to 5:30 PM with a 30-minute unpaid lunch, clock time is 8.5 hours but payable hours are 8.0.

Mistake 4 — Inconsistent Rounding

Applying different rounding rules to different employees, or different weeks, introduces errors that compound over time. If your workplace policy is 15-minute rounding, that rule must apply to every punch, every employee, every pay period. Inconsistent rounding is one of the leading reasons employers face wage claims.

Mistake 5 — Overtime Threshold Shifting Due to Decimal Errors

If decimal hours are even slightly understated, overtime thresholds shift. An employee who worked 40.5 hours appears to have worked 39.8, and gets regular pay on a week when overtime was legally owed.

A 0.25-hour error per person per week across 10 employees = 2.5 hours unpaid overtime weekly, 130 hours annually, and potentially thousands in back pay if a wage claim is filed.

How to Convert Decimal Time in Excel and Google Sheets

Converting hh:mm to Decimal in Excel

If your time is formatted as a duration (like 8:45), multiply the cell by 24:

=A1*24

Excel stores time as a fraction of a day. Multiplying by 24 converts it to decimal hours. If A1 contains 8:45, this formula returns 8.75.

Converting Decimal Back to hh:mm in Excel

Divide the decimal cell by 24, then format the result as [h]:mm:

=A1/24  →  format cell as [h]:mm

If A1 contains 8.75, this displays as 8:45.

In Google Sheets

The same formulas work in Google Sheets, time values are stored and calculated identically.

One important caveat: a misplaced formula, a cell reference that didn’t update when copied, or a skipped row can introduce errors that are hard to spot later. Unlike dedicated payroll software, a spreadsheet won’t flag when something looks off. Always review totals before submitting to payroll.

Decimal Time and Overtime Calculations

Overtime pay depends entirely on accurate decimal conversion. Under federal FLSA rules, the overtime threshold is 40 hours per week. In California, it’s 8 hours per day.

If decimal hours are understated even slightly, overtime thresholds shift. An employee who worked 40.5 hours appears to have worked 39.8, and gets regular pay on a week when overtime was legally owed.

This is exactly why this calculator converts to decimal automatically, so the number going into your pay calculation is always right.

Decimal Time for Salaried Employees

Overtime for non-exempt salaried workers: Salaried employees who don’t qualify for FLSA exemption are still entitled to overtime. Their regular rate is calculated by dividing their weekly salary by their expected hours, and overtime is then calculated in decimal format.

Billable hours for contractors: Consultants, lawyers, and freelancers billing by the hour track time in decimal format for invoicing. 6 hours and 12 minutes billed at $150/hour is 6.20 × $150 = $930.

Frequently Asked Questions

Why is 45 minutes 0.75 and not 0.45?

Because time runs on base-60, not base-100. There are 60 minutes in an hour, not 100. To convert, you divide by 60: 45 ÷ 60 = 0.75. Writing 0.45 treats minutes as if there were 100 of them in an hour — that’s a completely different number and produces incorrect pay calculations.

What is 8 hours 30 minutes in decimal?

30 ÷ 60 = 0.50. So 8 hours 30 minutes = 8.50 decimal hours.

What is 7 hours 15 minutes in decimal?

15 ÷ 60 = 0.25. So 7 hours 15 minutes = 7.25 decimal hours.

Does this calculator show decimal hours automatically?

Yes. Every calculation shows both hh:mm and decimal format. The decimal total is ready to enter directly into any payroll system.

Can I convert a full week of hours at once?

Yes. Enter each day separately and the calculator totals everything in decimal format for the full pay period.

What if my decimal total has more than two places, like 38.333?

Payroll systems typically round to the nearest hundredth, so 38.333 becomes 38.33. This rounding must be applied consistently and cannot systematically favor the employer. Two decimal places is sufficient for all standard payroll calculations.

One Formula, Total Confidence

Decimal time is the language payroll speaks. Once you understand how the conversion works, and where it tends to go wrong, you’re in full control of your own timecard accuracy.

The formula is simple: divide minutes by 60, then add the result to your whole hours. That single step is all that stands between clock time and a payroll-ready number.

This calculator handles the conversion automatically for every entry. Your decimal totals are always correct — ready to review, download, and submit with confidence.

[Use the Free Timecard Calculator →]