Converting Hours to Decimals in Excel

What this does

A time in Excel is a fraction of a day, so 7:30 is stored as 0.3125. Multiplying by 24 converts it into hours, by 1440 into minutes, and by 86400 into seconds. The step people forget is the second one: the result cell inherits the source's time format, so 7.5 is displayed back as 12:00 until you set the cell to General or Number. Going the other way — decimal hours into a time — divide by 24 and format as time, or use =TIME(hours, minutes, 0) if the parts are in separate cells. Converting minutes to hours is the same operation viewed differently: if A2 holds a plain NUMBER of minutes rather than a time value, =A2/60 gives decimal hours, and =A2/1440 gives a time value you can format as h:mm. Whether to divide by 60 or by 1440 depends entirely on whether the cell holds a number or a time, which is why checking the alignment first is worth the second it takes. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “converting hours to decimals in excel”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above before you touch the real workbook. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. The point is a data step that keeps your analysis trustworthy, but the practical win is that someone else can open the file and understand what happened without asking you.

A worked example

B2 holds the duration 7:30. =B2*24 formatted as Number with one decimal shows 7.5, ready to multiply by an hourly rate: =B2*24*C2 with a rate of 18.50 gives 138.75. In reverse, 7.5 in D2 back to a time: =D2/24 formatted as h:mm shows 7:30. And 135 plain minutes in E2: =E2/60 gives 2.25 hours, =E2/1440 formatted as h:mm gives 2:15. Every hourly-rate calculation needs the decimal form, and the ×24 is only half of it — the number format is what makes the answer readable. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.

In Google Sheets

Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “converting hours to decimals in excel” as a small building block rather than a chore. Once the inputs sit in their own cells and the formula reads from them, the same setup answers a dozen related questions with a tweak, and Excel keeps every dependent figure current as the data changes. The tool above is there so you can rehearse and verify before committing anything to a real workbook; the steps and worked example are there so the logic sticks. Get it right once and it stops costing you time — it starts saving it, every time the question comes back around.

Common mistakes

• Forgetting to change the number format, so the correct answer is displayed back as a time.
• Multiplying a text "7:30" by 24 and getting #VALUE! — convert it to a real time first.
• Dividing by 60 when the cell holds a time value rather than a count of minutes.
• Rounding each row to two decimals and then totalling, which drifts from the total of the unrounded values.
• Paying against the raw time value, which is a fraction of a day and roughly 24 times too small.

Frequently asked questions