You would need VBA or help formulas

http://www.cpearson.com/excel/DateTimeEntry.htm


--


Regards,


Peo Sjoblom




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