=--TEXT(A2,"00\:00")
and format as time.
--
David Biddulph

"Erin" wrote in message
...
I am working with data in Excel and have time stamps in the format of 24hr
time but it does not have a colon. For example 1321 or 843 instead of what
I
want 13:21 or 8:43.

Is there a way to either add a colon or change the format into a time
format. (I already tried just highlighting to change the format to time;
it
doesn't work.)