Convert Hours and Mins

Question

How do I convert hours and mins to a decimal in excel?

Answer 1

In Excel, time is stored as a fraction of a day, so one full day equals 1. That means one hour is 1/24 and one minute is 1/1440. To convert a time value into decimal hours, you usually just multiply the Excel time by 24.

If your value is a proper time like 2:30 in cell A1, the conversion to decimal hours is:

=A1*24

So 2:30 becomes 2.5 because 2 hours plus 30 minutes is two and a half hours.

If your hours and minutes are in separate cells, for example hours in A1 and minutes in B1, you can combine them like this:

=A1 + B1/60

That converts minutes into fractional hours and adds them to the hours.

If instead you already have a time value but Excel is displaying it oddly, you may also need to change the cell format to General or Number after applying the formula so you can see the decimal result rather than a time format.

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin