Re: converting general text to date time

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You could use TTC (Text to Columns).

Select the data, then:
<Data> <TextToColumns>, and click on "Fixed Width", then <Next>,

In the "Preview Window", click just in *front* of the "18",
So that the break line leaves the colon in the first column, and the second
column begins with the "18".
Then <Next>

In this last step of the Wizard, the first column (date) is selected by
default, so click on "Do Not Import".
You'll see the column header change to "Skip".
Now, click in the second (time) column to select it.
Then change the address in the "Destination" box from the default reference
(original data location), to an empty starting cell where you'd like the
times to end up.
Then click <Finish>.

Your original data will remain untouched, and the 'time' data will be in the
column you chose in the destination box.
Now, you can choose a format for how you wish to display the time data.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

<meyerelie@xxxxxxxxx> wrote in message
news:1148237572.325219.297130@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
im trying to extract time date from:

05:20:2006:18:45:50

i could use the mod function but the data is not in date time format.

How to i convert the above into date time format so that i can extract
the time data from it?

thanks


.

Relevant Pages

  • Re: Combining columns
    ... Sub columnmerge() ... 'original data is preserved and combine takes ... "Bernard Liengme" wrote: ... puts one row from the first column, then a row from the second, and then ...
    (microsoft.public.excel.worksheet.functions)
  • changing data
    ... to the first column of original data. ... Chris ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: changing data
    ... > to the first column of original data. ... Prev by Date: ...
    (microsoft.public.excel.newusers)