Convert Excel time to decimal hours
= A1 * 24
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.
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
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
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.