Good evening. I have a few spreadsheets that use start and end time to determine elapsed time. I use the 24 hour military format because it is instinctual for me and I don't have to explicitly type am or pm. I would also like to not have to leave the number pad to type a colon. I did a custom format that I thought would address that. It did after a fashion. If i type 13:00 the colon will disappear when I hit either enter or tab. But if I simply type 1300 it changes to 0000 when I move to the next cell. The closest I have come is that I made an autocorrect entry so I type "--" and it becomes a colon, which disappears when I move to the next cell. Can anyone suggest a different approach?

Capture.PNG