Convert minutes to decimal hours

Guide · last reviewed 1 November 2026 · Hours Calculator Online

Why 7:45 is 7.75 and not 7.45

A clock minute is one sixtieth of an hour. A decimal digit after the point is a tenth. Those two scales do not line up, so the minute figure cannot simply slide across the decimal point. Writing 7:45 as 7.45 claims the 45 minutes are forty-five hundredths of an hour — 27 minutes. You have just thrown away 18 minutes of someone's day.

Put numbers on it. At $24 an hour, 7.75 hours pays $186.00 and 7.45 hours pays $178.80. One shift, $7.20 short. Across a five-day week where every day ends on :45, that single habit costs $36.

The formula, in both directions

Minutes to decimal: decimal hours = whole hours + (minutes ÷ 60).

Decimal back to minutes: take the fractional part and multiply by 60. minutes = (decimal hours − whole hours) × 60. So 6.85 hours → 0.85 × 60 = 51 minutes → 6:51. The round trip is the fastest way to check a figure you do not trust: if multiplying the decimal part by 60 does not give back a sensible whole minute, something upstream is wrong.

Both conversions live in the hours to decimal converter, which updates either box as you type in the other, and the same arithmetic sits inside every other tool here — times are parsed into whole minutes, all the arithmetic is integer minute arithmetic, and decimal hours are produced only at the very end.

The full table: every minute from 1 to 60

This is the reference people actually want. Every whole minute, rounded to two decimals the way payroll systems round. Print the page and tape it next to the clock.

Read down the column you need and across to its pair. Four values are exact and need no rounding at all — 15, 30, 45 and 60 — which is exactly why quarter-hour thinking is so entrenched in payroll.

The quarter-hour quick table

Most time cards land on a quarter somewhere, and these four lines cover the bulk of everyday work. They are worth memorising because they are exact: no recurring decimal, no rounding, nothing to argue about.

Three worked conversions

Had the clerk written 9.37, the pay would have come out at $266.11 — a $7.10 gap from one misplaced conversion.

Sum the raw minutes, convert once. If instead you round each day first — 7.87, 8.13, 6.68, 9.22, 7.48 — the total is 39.38 as well, which is the usual outcome. But it is luck, not a guarantee, and the next section shows when the two methods part company.

The 0.2 of a minute left over is the fingerprint of the original two-decimal rounding. The true figure was somewhere between 34 h 34 min and 34 h 35 min; you cannot recover which from a rounded export, which is a good argument for keeping the minute-level record as the source of truth.

How big is the two-decimal rounding error, really?

Rounding to two decimals shifts any single entry by at most half a hundredth of an hour: 0.005 h, which is 0.3 of a minute, or 18 seconds. Only the minute values with a recurring third get clipped at all — the ones ending in 10, 20, 25, 35, 40 and 50, plus their immediate neighbours. Everything else is either exact or rounds by a sliver.

Those are worst cases, and they only arise if every single entry rounds in the same direction — which real minute values do not. In practice the ups and downs cancel and the annual drift is pennies. Still, two habits remove even that: store minutes as the record of truth, and total the minutes before converting. Do both and the rounding error is bounded by a single hundredth of an hour for the entire year, because you only round once.

Converting a whole timesheet at once

Day-by-day conversion is where small errors hide, because each row is a fresh opportunity to slide the minutes across the decimal point. Converting the sheet as a single operation is both faster and safer.

Work in three columns rather than two. Column one holds the clock times as entered. Column two holds the paid span in whole minutes. Column three holds decimal hours, derived from column two. Only column three gets rounded, and only when the week is complete.

One division, one rounding: 2410 ÷ 60 = 40.1666… → 40.17 hours. The h:mm figure of 40:10 is exact and needs no rounding at all, which makes it the better number to put on the employee-facing copy. Ten minutes past 40 also means this week crosses the federal overtime threshold, so the split between regular and premium hours has to be made before any rate is applied — overtime rules explained covers that step.

Why the base is 60 in the first place

Sixty is not an accident of clock design. It divides evenly by 2, 3, 4, 5, 6, 10, 12, 15, 20 and 30, which means halves, thirds, quarters, fifths and sixths of an hour all land on whole minutes. Decimal notation offers only halves, quarters-with-a-remainder, fifths and tenths cleanly. The two systems disagree exactly on thirds, which is why 20 and 40 minutes are the values that force a rounding decision and why they show up in every worked example on this page.

The one case where you should not convert

Keep h:mm when the number is going in front of a person who punched a clock, and use decimal when the number is going into a multiplication. An employee who worked 8 h 14 min recognises 8:14 instantly and has to stop and think about 8.23. Payroll cannot multiply 8:14 by an hourly rate without converting first. Showing both, side by side, ends more disputes than either format alone — which is why the calculators here always display the pair.

Doing it in a spreadsheet

If the minutes sit in A2 as a plain number, decimal hours are =A2/60. If A2 holds a real time value such as 7:45, use =A2*24 instead, because a spreadsheet stores a time as a fraction of a day. Going the other way, =TEXT(A2/24,"[h]:mm") turns 7.75 back into 7:45.

Two traps. First, format the decimal cell as a number, not as a time, or 7.75 will be reinterpreted as a date. Second, use ROUND(x,2) explicitly when the figure feeds pay; a cell that merely displays 7.33 may still be carrying 7.3333 into a multiplication, and the penny it moves will be the one someone notices.

Where this fits in a real payroll run

The order of operations that holds up under audit is: record punch times, apply any rounding policy to the punches, subtract unpaid breaks in minutes, total the week in minutes, split regular from overtime, then convert to decimal hours once for the pay calculation. Converting early forces you to round early, and early rounding is the thing you cannot unwind later.

If you want the number without the arithmetic, the work time calculator produces h:mm and decimal side by side for a single shift, the time card calculator does it for a full week, and how to calculate hours worked walks through the clock subtraction that comes before the conversion. Everything runs in your browser, with no account and no network request, and the formulas are covered by 50 automated unit tests.

A note on scope: the figures above are arithmetic, and arithmetic travels. The rules about which minutes are payable in the first place do not — they vary by state and by country. This page is general information rather than legal or payroll advice, so confirm the payability question with your employer's policy or your state labor agency.

Last reviewed 1 November 2026. Corrections welcome at our contact page.