Time format in a cell getting copied automatically into another ce

[Sasikiran]

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

 

[David Biddulph]

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")

 

[Sasikiran]

Hi David,

This is the data I get in a single cell.

linenum=52;seizetime=13:05:51

I want only the time format which was coming at the end "13:05:51" to get
copied into an another cell by a formula.

Hope you have understood.

Sasikiran

 

[David Biddulph]

If you are saying that you are starting with the text string
linenum=52;seizetime=13:05:51 and you want to extract the time from the end,
then the formula
=RIGHT(A1,8) will pull out 13:05:51 as a text string and =--RIGHT(A1,8)
will convert that to a number, which if you format the cell as hh:mm:ss will
be displayed as a time.

Another option is Data/ Text to columns/ Delimited, and select the = sign as
delimiter.

 

[Sasikiran]

Thanks a lot David.... Its working...

If you are saying that you are starting with the text string
linenum=52;seizetime=13:05:51 and you want to extract the time from the end,
then the formula
=RIGHT(A1,8) will pull out 13:05:51 as a text string and =--RIGHT(A1,8)
will convert that to a number, which if you format the cell as hh:mm:ss will
be displayed as a time.

Another option is Data/ Text to columns/ Delimited, and select the = sign as
delimiter.