This post will guide you how to convert Excel time to Decimal hours with a formula in Excel. How do I convert decimal hours to times in Excel 2013/2016.
Assuming that you have a list of data in range B1:B4, in which contain time values, and you want to convert it into decimal hours. How to accomplish it. You just need multiply by 24 for each cell, so just using the following formula:
If you want to convert a decimal hour to Excel Time, just simply divide by 24. So you can use the following formula:
Type this formula into a blank cell and press Enter key on your keyboard, then drag the AutoFill handle down to other cells to apply this formula.