"Andibevan" wrote in
:

What excel formula would I use to convert a number string i.e. 143254
to a time string, i.e. 14:32:54


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

and set the cell format to 13:30:55

--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)