=TEXT(A1,"00\:00")+0

format cell: hh:mm

"Suzanne" wrote:

I need to add a colon to military time. I need to change it from 1700 to
17:00. I want it to stay in military time. I don't want am or pm to show.
I can't figure out how to do this on the worksheet. Anyone know how to do
this?