Thanks Mangesh :-)


"Mangesh Yadav" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:ef2G%235KpFHA.4088@TK2MSFTNGP15.phx.gbl...
> assuming that your string is in A1, use:
>
> =TIME(LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2))
>
> format as time
>
> Mangesh
>
>
>
> "Andibevan" <Andibevan@notehere-hotmail.com> wrote in message
> news:uP6$T1KpFHA.1464@TK2MSFTNGP14.phx.gbl...
> > Hi there,
> >
> > What excel formula would I use to convert a number string i.e. 143254 to
a
> > time string, i.e. 14:32:54
> >
> > I need it to be as a formula so it is automated and not a manual
process.
> >
> > Thanks in advance
> >
> > Andi
> >
> >
>
>