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 result in in TEXT so that when I copy/paste to another spreadsheet, not mine so can't format as I want, it still shows 14:45 even if the format on that spreadsheet is Number > General?
Any help please?
With decimal hours in A2, you could use the formula
=TEXT(A2/24, "hh:mm")
to return the corresponding time as a text value.
4 Replies
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.
With decimal hours in A2, you could use the formula
=TEXT(A2/24, "hh:mm")
to return the corresponding time as a text value.
