**Convert Excel time to decimal hours**

**Formula**

`= A1 * 24`

**Explanation**

Here’s how to convert Excel time to the decimal hour.

First, one needs to remember that in the way time works on Excel, a 24-hour period is represented by 1. i.e. 24 hours = 1. The ripple effect of this is that every other hour of the day fall below the whole number 1 and can be addressed infractions.

Since every hour is practically a fraction of the day (e.g. 1/24, 3/24, etc.), you can then convert a particular Excel time to decimal hours by simply multiplying its value by 24.

**Example 1**

*Figure 1. Example of how to convert Excel time to decimal hours.*

Assuming you’re asked to convert an Excel time like 4:00 in a typical cell for instance, here’s how the conversion to a decimal hour would look like.

Remember our formula here is `B5 * 24.`

Where B5 = 4 divided by 24.

Then, the decimal hour becomes (4/24) * 24

= 0.167 * 24

= 4.008

~4.0

**Example 2**

*Figure 2. Example of how to convert Excel time to decimal hours*

In this example, we consider a more complex conversion like when you’re asked to convert an excel time of 9:00 PM. Now, you must realize that there’s a difference between AM and PM conversions. In this case, this is how you do convert the Excel time to the decimal hour.

On a 24-hour scale, 9:00PM is 21 hours. Then, still using our formula. This time, B9 * 24, you have:

= (21/24) * 24

= 0.875 * 24

= 21

**Notes**

In Excel, when you attempt to convert a particular Excel time to decimal hours by multiplying the time value by 24, it is often so that Excel returns a result with the h:m format and may ultimately show you the actual value incorrectly.

## Leave a Comment