From: Toria on
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.
From: Gary''s Student on
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.
From: T. Valko on
**Maybe** this...

=--TEXT(A1,"00\:00\:00")

Format as Time

--
Biff
Microsoft Excel MVP


"Toria" <Toria(a)discussions.microsoft.com> wrote in message
news:65E04B28-D132-40F5-8D1A-8D910C913AAE(a)microsoft.com...
> 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.


From: Toria on
Thank you! It worked perfectly!

"Gary''s Student" wrote:

> 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.
From: alanglloyd on
On May 12, 5:41�pm, Toria <To...(a)discussions.microsoft.com> 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.
>

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