Text to time convert

[Guest]

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

 

[Ron Rosenfeld]

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

 

[Mladen_Dj]

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.