Explanation
In the Excel time system, one 24-hour day is equal to 1.
To display the result as a regular number, apply theGeneral or Number format.
Convert Excel time to decimal hours
To convert a valid Excel time into decimal hours, multiply by 24. In the example shown, the formula in C6 is: =B6*24 As the formula is copied down, it converts the native Excel times in column B into decimal hours. Note: to figure out the number of hours between a start time and an end time, see: Calculate hours between two times.
