Forum Discussion
Converting numbers in decimal to hours & minutes
How can I convert the numbers I have with 2 decimal places to hours:minutes?
as noted above you need to do either:
=FORMAT( A1/24, "HH:MM") or =A1/24 and change the cell formatting to show time.
the first option (FORMAT(..)) will convert it to text string (i.e. you can add or do value comparisons)
the second converts the value but then you need to go to HOME -> Cell Format go to more and then in the pop up select time and then the time format you want.
=FORMAT( A1/24, "HH:MM") or =A1/24 and change the cell formatting to show time.
the first option (FORMAT(..)) will convert it to text string (i.e. you can add or do value comparisons)
the second converts the value but then you need to go to HOME -> Cell Format go to more and then in the pop up select time and then the time format you want.
mtarler I have tried what you say.
In MHO It does not work.
BTW I still cannot understand why the TIME formats seem not to do what I would expect.
Almost all other formats are reasonable.
If I have a number that is 2.38 and I select a TIME format I should NOT get
09:07:12 or 57:07:12 or 57:07 (depending on the specific format selected)