Time Format Question

  • Thread starter Thread starter Toria
  • Start date Start date
T

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.
 
With your values in column AA, try:

=TIME(LEFT(A1,LEN(A1)-4),LEFT(RIGHT(A1,4),2),RIGHT(A1,2))
 
Hello,
I currently have time entered like this:
173517
90207

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

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
 
Back
Top