View Single Post
  #1   Report Post  
Rudo
 
Posts: n/a
Default Text to time convert

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