Time Format Question

[Toria]

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.

 

[Gary''s Student]

With your values in column AA, try:

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

 

[Toria]

Thank you! It worked perfectly!

With your values in column AA, try:

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

 

[alanglloyd]

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

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

if you don't mind oapitals for AM /PM then format the cell (right-
click > Format Cells > Number | Custom) and enter . . .

h:mm AM/PM

Alan Lloyd