Prev: IF formula help?
Next: Combination of IF, AND, and COUNTIF; need help
From: Toria on 12 May 2010 14:41
Yes, that works too. Thanks!

"T. Valko" wrote:

> **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: T. Valko on 13 May 2010 00:11
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Toria" <Toria(a)discussions.microsoft.com> wrote in message
news:B0518FB7-150C-4BC4-8357-79F9E9F79045(a)microsoft.com...
> Yes, that works too. Thanks!
>
> "T. Valko" wrote:
>
>> **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.
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: IF formula help?
Next: Combination of IF, AND, and COUNTIF; need help