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

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

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" wrote:

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

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.
--
David Biddulph

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

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

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

"David Biddulph" wrote:

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.
--
David Biddulph

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

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