Convert Excel time to decimal hours

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.                                                                                                                                                                                                                                                                                       

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar