Convert Excel time to decimal hours
To convert a valid Excel time into decimal hours, simply multiply by 24. In the example shown, the formula in C6 is:
which returns a value of 1.
How this formula works
In the Excel time system, one 24-hour day is equal to 1. This means times and hours are fractional values of 1, as shown in the table below:
Because each hour can be represented as 1/24, you can convert an Excel time into decimal hours by multiplying the value by 24. For example, with the time value 6:00 cell A1, you can visualize the conversion like this:
=A1*24 =(6/24)*24 =0.25*24 =6
Format result as number
When you multiply a time value by 24, Excel may automatically format the result using a time format like h:mm, which will display the value incorrectly. To display the result as a regular number, apply the General or Number format.