## Convert decimal hours to Excel time

This tutorial shows how to Convert decimal hours to Excel time using example below. To convert hours in decimal format to a value Excel recognizes as time, divide by 24. Formula =hours/24 Explanation In the example shown the formula in C5 is: =B5/24 which returns 0.04167, the equivalent of 1 hours. Cell D6 shows the …