Note the other answer will fail on say 91015, they will give 19:01:15.

If you are going to use the string method you should use

=TIME(LEFT(A1,LEN(A1)-4),MID(A1,3,2),RIGHT(A1,2))

--
HTH

Bob Phillips

"Andibevan" wrote in message
...
Thanks Mangesh :-)


"Mangesh Yadav" wrote in message
...
assuming that your string is in A1, use:

=TIME(LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2))

format as time

Mangesh



"Andibevan" wrote in message
...
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