Hi Gord

just what I need.
Thanks.

"Gord Dibben" wrote:

What I do with something like this is use DataImport External DataNew Web
Query

Enter the URL in the dialog and go.

Select the range to import by clicking on the yellow "x"

Go to Options and "disable Date recognition"

Now hit Import.

The numbers are not converted to dates.

Elsewise, copy the data from the site and paste into Notepad.

Save as a *.txt file and open that in Excel which gives you the Text Import
Wizard where you set the column data format as Text.


Gord Dibben MS Excel MVP

On Tue, 7 Apr 2009 08:58:06 -0700, Jesse
wrote:

good morning:

let me start from the beginning. I am importing this data from trackmaster,
which is a horse racing data. What I would like to do is analyze adding and
subtracting the speed of the horses, but since it comes in the time format,
not as a number is what my problem is. I can send you some samples. My
email is




"Fred Smith" wrote:

You're making it difficult to provide help. Excel we're good at. Mindreading
not so good.

Do you want to display a time without colons?
If so, how do you want to display a time like 1:30.8?
Or, do you want to enter a time without colons?

Give an examples of what you have, and what you want to see.

Regards,
Fred.

"Jesse" wrote in message
...
Thanks Fred for this info
yes my question is how to remove the colons?

"Fred Smith" wrote:

Your sample shows only times. That's not much to go on. As a guess:

-- to "remove" a format, change it to any other, like General or a
numeric
format.
-- if you are asking how to convert a time to a number of, say, minutes,
multiply by 1440 and format as a number.

Regards,
Fred.



"Jesse" wrote in message
...
how to remove existing format, like time to regular number see sample
:30.8 :58.8 1:28.4
:27.8 :57.2 1:26.2
:31.0 1:00.4 1:29.6
:32.4 1:02.2 1:31.4
:30.0 1:00.8 1:32.2
:28.4 :57.6 1:28.0
:28.2 :58.2 1:28.4
:30.8 1:01.8 1:31.8
:31.6 1:01.8 1:31.4
:28.8 1:00.2 1:29.8
:32.4 1:02.2 1:31.4
:30.0 1:00.8 1:32.2
:30.2 :59.4 1:29.8
:29.8 1:01.4 1:31.2