Hi,

I have a problem where when I export some logs in an excel format the data
is getting exported in a jumble format. Even after using text to columns
option in the data tool, in one of the column a text is getting mixed with
the time format. I need the time format to be copied in another column
thorugh a formula where I can check the criteria I require.

Below is the case appearing in one cell of a column in which the time format
13:05:51 has to be seperated by a formula into an another cell.

linenum=52;seizetime=13:05:51

Is this possible?

Thanks in advance
Sasikiran