Forum Discussion
Converting numbers in decimal to hours & minutes
How can I convert the numbers I have with 2 decimal places to hours:minutes?
Let's say you have such values in D2 and down.
In E2:
=INT(D2)/24+MOD(D2,1)/14.4
Format E2 as time, then fill down.
But the time as a decimal 3.24 would be more like 3:15 or 3:14 and not 3:24, so that doesn't work