=TIME(INT(A21/10000),INT((A21-INT(A21/10000)*10000)/100),MOD(A21,100))

--
HTH

Bob Phillips

"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
>
>