Forum Discussion
Solved
Get time of day from decimal hours
I have a formula that tells me I have done 14.75 hours. As the starting point was 10:30 AM I want to convert the 14.75 decimal hours to 14:45 (HH:MM) How do I do this in Excel AND ensure that the...
With decimal hours in A2, you could use the formula
=TEXT(A2/24, "hh:mm")
to return the corresponding time as a text value.
That will be =14.75/24 and apply time format to the result
If I apply the time format to that calculation will when I copy/paste to another spread be in the TERXT format HH:MM.