Hello excellers,

I am wondering how we could convert numbers to 24 hour time format as we key in the numbers?

Example:
As we key in 0815, it would automatically convert to 08:00.
As we key in 1345, it would automatically convert to 13:45.

What is the code we could use to put in the code of the sheet?

Many thanks!