=TIME(INT(A21/10000),INT((A21-INT(A21/10000)*10000)/100),MOD(A21,100))
--
HTH
Bob Phillips
"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
|