Forum Discussion
Converting numbers in decimal to hours & minutes
How can I convert the numbers I have with 2 decimal places to hours:minutes?
mtarler The number now just a number with 2 decimal places
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.