With your value in A1, in say B1
=TIME(LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2))
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
"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
|