My question is:
Is it possible to format a cell so it displays a number as time format?
For example, I want type 1445 and I would like it to be displayed as 14:45 in time format.
The importat thing here is the "time format" part. I can format the cell with
##":"##, but this doesn't allow me to use the value like the time format.