FreeMyTools

Convert Minutes to Decimal Hours for Payroll

Turn hours and minutes into the decimal hours a timesheet expects.

Hours and minutes → decimal
hours
minutes
7.75

decimal hours

Decimal → hours and minutes decimal hours 7h 45m

hours and minutes

Excel formula

=45/60

For a real time value such as 7:45, use =A1*24 instead and format the result as a number.

Keyboard Shortcuts ?
  • Convert Enter
  • Toggle This Guide ?
  • Toggle Dark Mode D
  • Focus Primary Input /
  • Clear or Close Esc

Convert Minutes to Decimal Hours for Payroll

Timesheets are filled in as hours and minutes. Payroll systems want decimal hours. The conversion is one division — minutes ÷ 60 — but doing it forty times for a weekly timesheet is where mistakes creep in, and the mistakes cost money.

The error that shows up most often is reading the decimal as minutes: writing 8.45 for 8 hours 45 minutes. The correct value is 8.75. Over a fortnight of shifts that is real underpayment, and it is easy to miss because 8.45 looks plausible.

Minutes to Decimal Chart

Minutes converted to decimal hours, in five-minute steps
Minutes Decimal Exact
5 min 0.08 0.0833
10 min 0.17 0.1667
15 min 0.25 0.25
20 min 0.33 0.3333
25 min 0.42 0.4167
30 min 0.50 0.5
35 min 0.58 0.5833
40 min 0.67 0.6667
45 min 0.75 0.75
50 min 0.83 0.8333
55 min 0.92 0.9167
60 min 1.00 1

The quarter hours are worth committing to memory: 15 = 0.25, 30 = 0.5, 45 = 0.75. Those three cover most shift patterns. Everything else is minutes ÷ 60.

Converting Minutes to Decimal in Excel

Which formula you need depends on how the cell is stored, and getting this wrong is the usual reason a spreadsheet returns something absurd:

  • Minutes as a plain number (a cell containing 45) → =A1/60
  • A real time value (a cell containing 7:45) → =A1*24, then format the result as a number, not as a time. Excel stores times as a fraction of a day, so 7:45 is really 0.3229 — multiplying by 24 converts it to hours.
  • Hours and minutes in separate columns → =A1+B1/60

If a formula returns something like 0.32 when you expected 7.75, the cell is a time value and you used the plain-number formula. Switch to =A1*24.

Rounding and How Much It Matters

Some minutes do not divide evenly into an hour. Ten minutes is 0.1666… recurring, and twenty is 0.3333…. Two decimal places is the payroll standard and loses under a second per entry, which no system will care about — but the converter above shows the exact value as well, in case yours accepts more precision.

Separately, some employers round clock times to the nearest quarter hour before converting. US federal rules permit that provided the rounding is neutral over time rather than consistently favouring the employer. That is a policy question for your workplace, not a maths one — this tool converts whatever minutes you give it.

Not Looking for Time?

"Minutes to decimal" also describes converting geographic coordinates — degrees, minutes and seconds into decimal degrees. That is a different calculation (degrees + minutes/60 + seconds/3600) and this page will give you the wrong answer for it. This converter is for time: timesheets, payroll, and billable hours.

Frequently Asked Questions

How do you convert minutes to decimal hours?

Divide the minutes by 60. Thirty minutes is 30 ÷ 60 = 0.5 hours; 45 minutes is 45 ÷ 60 = 0.75. If you also have whole hours, keep them as they are and add the decimal part — 7 hours 45 minutes becomes 7.75.

What is 15 minutes in decimal?

0.25 hours. The quarter hours are the ones worth memorising: 15 minutes is 0.25, 30 is 0.5, 45 is 0.75. Between them, each minute is roughly 0.0167 of an hour, which is why the awkward values need a chart or a calculator.

What is 45 minutes in decimal?

0.75 hours, because 45 ÷ 60 = 0.75. A shift of 8 hours 45 minutes is therefore 8.75 hours on a timesheet — not 8.45, which is the single most common payroll entry error.

Why does payroll use decimal hours instead of minutes?

Because pay is hours multiplied by a rate, and that only works if hours are a single number. You cannot multiply 7 hours 45 minutes by £12.50 directly, but you can multiply 7.75. Every payroll system stores time this way for the same reason.

How do I convert minutes to decimal in Excel?

If the minutes are a plain number in A1, use =A1/60. If A1 holds a real time value such as 7:45, use =A1*24 and format the result as a number — Excel stores times as fractions of a day, so multiplying by 24 gives you hours.

How do you convert decimal hours back to minutes?

Multiply the decimal part by 60. For 7.75 hours, 0.75 × 60 = 45, so it is 7 hours 45 minutes. The converter above does this direction too — enter a decimal and it shows the hours and minutes.

Is 1.5 hours the same as 1 hour 50 minutes?

No. 1.5 hours is 1 hour 30 minutes, because 0.5 of an hour is half of 60 minutes. Reading the decimal as if it were minutes is the classic mistake — 1 hour 50 minutes is 1.83 hours.

Should I round timesheet minutes before converting?

Only if your employer's policy says so. Some workplaces round to the nearest quarter hour, which US federal rules permit provided the rounding is neutral over time rather than always in the employer's favour. If there is no stated policy, convert the exact minutes.

How many decimal places should I use?

Two is standard for payroll and is what most systems accept. Some minutes do not divide evenly — 10 minutes is 0.1666… — so two decimal places means a rounding difference of under a second per entry. Use the exact value if your system takes it.

Related Tools