On Sun, 13 Nov 2005 10:54:01 -0800, "Rudo"
wrote:

How can I convert text to time format in cell.

i.e text in cell A1 is 163233 - 16 is hour, 32 is min and 33 is sec.
I need convert this text to time format: 16:32:33

Thanks for help, Rudo

=--TEXT(A1,"00\:00\:00")

Format the cell as [hh]:mm:ss (or similar)


--ron