Convert 3 digit or 4 digit number to time format

Hi folks

Probably simple, I hope. In cell K19 I have a user entry which can be any 24-hour format time, eg, 820 (8:20am), 1020 (10:20am), or 1630 (4:30pm)
I do not want to express the AM or PM element, but simply put a colon before the last two digits. SO the times above would equate to 8:20, 10:20 and 16:30 respectively.
The result is NOT used for analysis or further use. It's just an information only cell!

Any help appreciated. I have put the code below that it will appear in...

Please Login or Register  to view this content.

Thanks in anticipation
Pete

try:

Please Login or Register  to view this content.