convert number format to time format

  • Thread starter Thread starter fullymooned
  • Start date Start date
F

fullymooned

I have a whole column in which I need to be able to enter a number an
it should convert it to the time format. If I enter 100 it shoul
convert it to 1:00. Similarly entering 2300 should automatically b
converted to 23:00.

Thank yo
 
Back
Top