If you are saying that you want to include the result of one cell (in time
format) into another cell with some text, then try something like:
="seizetime="&TEXT(A1,"hh:mm:ss")
--
David Biddulph

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