Quick answer

Convert minutes to decimal hours by dividing the minutes by 60, then add any whole hours. For example, 45 minutes is 45 ÷ 60 = 0.75 hours, so 2 hours 45 minutes becomes 2.75 hours. Do not write 2:45 as 2.45: the digits after a decimal are hundredths, not minutes.

This guide is written for freelancers, payroll administrators, bookkeepers, and service teams converting timesheets into invoice or payroll totals who want time tracking to support better planning, billing, reporting, and project decisions.

Use this minutes-to-decimal formula

The formula is decimal hours = whole hours + (minutes ÷ 60). To convert 3 hours 20 minutes, calculate 20 ÷ 60 = 0.3333, then add 3 for a result of 3.3333 hours. If the destination accepts two decimal places, that displays as 3.33 hours.

Keep more precision during the calculation and round only the final total. Rounding every individual entry first can make a weekly total drift away from the time actually worked, especially when a person records many short tasks.

  • 15 minutes = 0.25 hours
  • 30 minutes = 0.50 hours
  • 45 minutes = 0.75 hours
  • 1 hour 15 minutes = 1.25 hours
  • 7 hours 30 minutes = 7.50 hours

Decimal hours conversion chart

For exact hundredths, the useful sequence is: 1 minute = 0.02, 5 = 0.08, 10 = 0.17, 15 = 0.25, 20 = 0.33, 25 = 0.42, 30 = 0.50, 35 = 0.58, 40 = 0.67, 45 = 0.75, 50 = 0.83, 55 = 0.92, and 60 = 1.00. These values are rounded to two decimal places.

A chart is convenient for a paper timesheet, but a formula is safer for totals. Six entries rounded independently can differ from the decimal result of their combined minutes. Add the raw minutes, divide that total by 60, and round once at the end.

Convert decimal hours back to minutes

To reverse the calculation, keep the whole hours and multiply only the decimal part by 60. For 4.35 hours, keep 4, then calculate 0.35 × 60 = 21 minutes. The result is 4 hours 21 minutes.

This reverse check catches a surprisingly common billing error. A value of 4.35 does not mean 4 hours 35 minutes. If somebody typed clock notation into a decimal field, the invoice will be twelve minutes short for that entry.

Handle rounding without changing the record

Decimal conversion and billing increments are separate operations. Conversion expresses the same duration in a different format. Rounding changes the duration used for billing or payroll. Preserve the original start, stop, and minute total, then apply any agreed rounding rule after conversion.

For client work, state the billing increment in the engagement terms and apply it consistently in both directions. For employee pay, follow the law and policy that applies to the workplace; a convenient decimal chart does not replace an accurate record of hours worked.

Calculate decimal hours in Excel or Google Sheets

If cell A2 contains a real spreadsheet time such as 7:30, use =A2*24 and format the result as a number. Spreadsheet time is stored as a fraction of a 24-hour day, so multiplying by 24 returns decimal hours. If hours are in A2 and minutes are in B2, use =A2+(B2/60).

Do not type 7.30 into a cell and expect the spreadsheet to understand 7 hours 30 minutes. That input is already the decimal number seven and three tenths. Enter 7:30 as time, or keep hours and minutes in separate columns.

When you should skip manual conversion

A conversion chart is useful for correcting an occasional paper record. It is a poor operating system for a team that submits dozens of entries every week. Manual conversion adds a second version of each duration and gives transcription errors a place to hide.

Use a timer or timesheet that stores the actual duration and produces decimal totals automatically when hours feed invoices, project budgets, or payroll. Keep the manual formula for checking the output, not recreating an entire week from memory.

Where Zeitio fits

Zeitio helps teams connect tracked hours to clients, projects, tasks, reports, approvals, and invoices so time data becomes useful business context instead of another spreadsheet.

Start with simple time entries, review them weekly, and use the data to improve project planning, billing accuracy, and team workload decisions.

Compare Zeitio pricing or create a workspace to try the workflow.

Further reading

FAQs

How do I convert minutes to decimal hours?

Divide the minutes by 60. For a duration containing whole hours, add them afterward: 2 hours 45 minutes is 2 + (45 ÷ 60), which equals 2.75 decimal hours.

What is 15 minutes as a decimal?

Fifteen minutes is 0.25 hours because 15 divided by 60 equals 0.25. Therefore, 1 hour 15 minutes is 1.25 hours.

What is 30 minutes as a decimal?

Thirty minutes is 0.50 hours. It is half of a 60-minute hour, so 7 hours 30 minutes becomes 7.50 decimal hours.

Is 1 hour 30 minutes written as 1.30 hours?

No. One hour 30 minutes is 1.5 hours. The value 1.30 hours means 1 hour plus 0.30 of an hour, and 0.30 multiplied by 60 is 18 minutes.

How do I convert decimal hours to hours and minutes?

Keep the whole number as hours and multiply the decimal part by 60. For 2.75 hours, 0.75 multiplied by 60 is 45, so the result is 2 hours 45 minutes.