Convert Excel time to decimal hours in Excel
This tutorial shows how to Convert Excel time to decimal hours using example below. To convert a valid Excel time into decimal hours, simply multiply by 24. Formula =A1*24 Explanation In the example shown, the formula in C6 is: =B6*24 which returns a value of 1. How this formula works In the Excel time system, …