How to Convert Minutes to Decimal Hours for Payroll

A timesheet says 7 hours 45 minutes. The payroll system wants a single number. If you type 7.45, the employee is underpaid. If you type 7.75, the pay is right. That small difference is why understanding decimal hours matters for anyone who handles hours and pay: employees, managers, bookkeepers and freelancers.

Why payroll uses decimal hours

Pay is calculated by multiplying hours by an hourly rate. Multiplication works naturally in base 10, but clock time works in base 60 – there are 60 minutes in an hour, not 100. To multiply time by money, you must first express the time as a decimal fraction of an hour. That decimal number is what payroll software, invoices and spreadsheets expect.

The formula

Decimal hours = Hours + (Minutes ÷ 60)

If you also have seconds: Decimal hours = Hours + (Minutes ÷ 60) + (Seconds ÷ 3600).

Examples:

• 7 h 45 min = 7 + 45/60 = 7 + 0.75 = 7.75 hours
• 8 h 20 min = 8 + 20/60 = 8 + 0.333… = 8.33 hours
• 5 h 10 min = 5 + 10/60 = 5 + 0.1667 = 5.17 hours
• 0 h 50 min = 50/60 = 0.83 hours

Quick reference chart

These are the conversions you will use most often (rounded to two decimal places):

The minutes to decimal page includes a full 1–60 minute chart.

A worked pay example

An employee earns $18.00 per hour and worked 38 hours 40 minutes this week.

• Correct: 40 ÷ 60 = 0.667, so 38.67 hours × $18 = $696.06
• Wrong: entering 38.40 hours × $18 = $691.20

The mistake costs the employee $4.86 that week. It looks small, but repeated every week across a team it adds up – and it can create compliance problems for the employer. (The figures here are illustrative; currency and rates don't change the math.)

Converting decimal hours back to minutes

Sometimes you need to go the other way – for example, when a report shows 6.4 hours and you want to know what that means in clock time. Multiply the decimal part by 60: 0.4 × 60 = 24 minutes, so 6.4 hours = 6 hours 24 minutes. The decimal to time converter does this for you.

Rounding: how many decimal places?

Two decimal places (hundredths of an hour) are the most common in payroll, and each hundredth is 0.6 minutes. Some employers use one decimal place (tenths – 6-minute increments) or quarter hours (0.25 – 15-minute increments). Whatever you use:

• Round once, at the end. Converting each day to two decimals and then adding can produce small differences compared with adding the minutes first. Add the exact times, then convert the total.
• Follow your policy. Rounding rules for time records may be regulated where you work. When in doubt, ask your payroll department or check local labor guidance.
• Be consistent. Use the same method every pay period so totals can be audited.

Doing it in a spreadsheet

In Excel or Google Sheets, time values are stored as fractions of a day. If cell A1 contains a duration like 7:45, the formula =A1*24 returns 7.75. Format the result cell as a number, not a time. If you have separate hours and minutes columns, use =B1+C1/60.

Decimal hours on invoices

Freelancers and contractors face the same issue when billing clients. If you tracked 3 hours 50 minutes on a task, your invoice should show 3.83 hours, and at $40/hour the line total is $153.20 – not $154.00 (which is what 3.85 would give) and certainly not $152.00 (3.80). Clients are more likely to trust an invoice when the decimal hours match the clock times you report. A simple practice is to keep a column for clock time and a column for decimal hours side by side, so anyone can verify the conversion. If you bill in fixed increments such as 6 or 15 minutes, agree on that with the client first and note it on the invoice.

Common mistakes

• Writing minutes after the decimal point (7.45 instead of 7.75).
• Rounding each day and then adding the rounded values.
• Forgetting to subtract unpaid breaks before converting – see how to calculate hours worked.
• Applying overtime to the wrong total – see overtime calculation basics.

Frequently asked questions