With your values in column AA, try:

=TIME(LEFT(A1,LEN(A1)-4),LEFT(RIGHT(A1,4),2),RIGHT(A1,2))

--
Gary''s Student - gsnu201003


"Toria" wrote:

Hello,
I currently have time entered like this:
173517
90207

I need to look like this:
5:35 p.m.
9:02 a.m.

I've done a ton of research but nothing has worked so far.

Thank you.