Convert four digits to time upon data entry

[Biking Loki]

I've seen a few thread about how convert an adjacent cell to xx:xx time format. However, is there a way to format the cell so that when I type '1330' and press enter, it will automatically convert to 13:30?

 

[Scott Huish]

Did you try my code?

 

[Biking Loki]

Did you try my code?

Yes. Your code and jasmith4's code resulted in the same errors. ???

 

[CharlesChuckieCharles]

Hot Pepper's answer far more logical

and works fine

Are you putting is in the SHEET module?