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

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

If your time value always have 6 digits, use formula:

=VALUE(LEFT(A1,2)&":"&MID(A1,3,2)&":"&RIGHT(A1,2)) , and format cell as
hh:mm:ss.

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