How to Convert Minutes to Decimal Hours for Payroll

A timesheet says an employee worked 6 hours and 47 minutes. Their rate is $18.50 an hour. Multiply 6:47 by $18.50 directly and the number that comes out means nothing — hours and minutes don't behave like a normal number, because an hour holds 60 minutes, not 100. Before that pay can be calculated, the time has to be converted into decimal hours: a single base-ten number like 6.78 that a calculator, spreadsheet, or payroll system can multiply by a wage without translation.

This is the exact conversion — the formula, a full worked example through to a dollar figure, the mistake that trips up almost everyone at least once, and how to do it correctly in a spreadsheet. If you clock in and out and just need total hours worked before converting anything, see our guide on how to calculate hours worked first.

A clock reads in base 60 — 60 minutes to an hour — but money is counted in base 10. Wages, spreadsheets, and payroll formulas all expect a plain number they can multiply, and 6:47 isn't one: it's really two separate numbers glued together with a colon. Decimal hours resolve that mismatch by expressing the whole thing as one base-ten value, 6.78, that behaves exactly like any other number in a calculation.

This is different from converting minutes to hours for a general duration — "the movie was 1 hour 47 minutes long" doesn't need to become a decimal, because nobody is multiplying it by anything. Payroll's decimal-hours conversion exists specifically because the next step is always the same: multiply by an hourly rate.

There's only one rule, and it applies to every case:

That's the entire method. There's no separate rule for different minute counts and nothing to memorize beyond "divide by 60" — the quick-reference table further down just saves you from doing that division for the values you'll hit most often.

Notice the decimal-hours figure itself was never rounded before the multiplication — that matters, and the next section shows exactly why.

A handful of minute values come up constantly on timesheets. Here they are pre-converted, rounded to two decimal places:

Only 15, 30, and 45 minutes produce perfectly clean decimals — a quarter, a half, and three-quarters of an hour. Every other value is a repeating or rounded decimal, which is normal and not a sign anything's wrong. For the full minute-by-minute table from 1 to 59, see the complete payroll minutes-to-decimal chart.

On a single timesheet the error looks small. Read 30 minutes as 0.30 instead of 0.50 on a $20-an-hour shift and the pay comes out $4 short for that one entry — and it repeats every time that employee logs a half hour, on every pay period, for as long as the error goes unnoticed.

Go back to the worked example: 6 hours 47 minutes at $18.50 an hour. Carried through unrounded, 6.7833 hours times $18.50 comes to $125.49. But if you round the decimal hours to two places first — to 6.78 — and multiply that instead, you get $125.43. Same shift, same rate, six cents apart, purely because of when the rounding happened.

Neither number is "wrong" exactly, but the two approaches don't agree, which is why it's worth knowing which one your payroll software uses. A reasonable default is to keep the decimal-hours value at full precision through the calculation and round only the final pay figure to the nearest cent; some systems instead round the decimal hours first for a cleaner-looking timesheet, accepting the small difference. Either way, this is separate from rounding raw clock times to the nearest 5 or 15 minutes before conversion, which is its own policy — see our guide to timesheet rounding and the 7-minute rule for that step.

The formula is the same in Excel or Google Sheets, but which version you use depends on how the time is stored:

• Minutes stored as a plain number (a column showing 407 for total minutes worked): divide by 60 — =A2/60.
• Hours and minutes in separate columns (6 in column A, 47 in column B): add the hours to the converted minutes — =A2+(B2/60).
• A real time value, formatted as a clock time rather than plain text (the cell shows 6:47 and is right-aligned like a number): multiply by 24 instead of dividing by 60 — =A2*24. Spreadsheets store time values as a fraction of a full 24-hour day, so this converts it back into hours directly.

Mixing these up — dividing a real time value by 60, for instance, instead of multiplying it by 24 — is the most common spreadsheet-specific version of this error, and it produces a number small enough that it's easy to miss on a quick glance.

For minute counts that aren't in the quick-reference table, there's a shortcut that avoids dividing by 60 directly: divide the minutes by 6, then move the decimal point one place to the left. That works because minutes ÷ 60 is the same as (minutes ÷ 6) ÷ 10.