Input number, then auto-formatted as HH:MM

[smallxyz]

Hi,


When I input 8 on a cell, how do I configure it to be auto-display as 08:00?


Also, when I input 16 on a cell, it will display as 16:00?

Similarly, when I input 24 on a cell, it will display as 00:00?


Thanks.

 

[HeyItsDizzy]

You can do this with a calculation, eg;
Cell A1 = 16 (you want that to read 16:00)
you can put a formula in Cell B1 ' =A1*(1/24)

this will return the value of ' 0.666666666666667 '

but if you format Cell B1 as a 'Time' you can use the preset ones in the ribbon at top of your workbook, or you can right click the cell, go to "Format cells..." and click Custom and choose the 'hh:mm' selection and your cell will display 16:00

 

[smallxyz]

THanks Dizzy!