Time Format Question
in [Functions]
|
From: Toria on 12 May 2010 12:41 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 12 May 2010 12:54 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 12 May 2010 13:53 **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 12 May 2010 14:03 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 12 May 2010 14:27
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 |