Text to time convert

R

Rudo

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
 
R

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
Click to expand...

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

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


--ron
 
M

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.
 
Top