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...

Sub TimeConv1()

        Sheets("PatientTransport").Range("K19") = INSERT CODE HERE        
End Sub
Thanks in anticipation
Pete