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

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

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

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

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

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

Why can't you work with times? Isn't that what you are looking for -- how
much time it took the horse to run the race?

Even if you sent me a sample, you still haven't said what solution you seek.
As most people don't like dealing with files because of the risk of viruses,
they post examples in their messages. Why is it so difficult to post an
example of what you have, and what you need?

Regards,
Fred.

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

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

Hi Fred see the sample

Column1 Column2 Column3 Column4 Total
:30.8 :58.8 1:28.4 2:00.0 #VALUE! I use the formula to add
:27.8 :57.2 1:26.2 1:53.6 #VALUE! Sum (a1:a4) = #Value
:31.0 1:00.4 1:29.6 1:58.2 #VALUE! and I get a Value
:32.4 1:02.2 1:31.4 2:00.4 #VALUE!
:30.0 1:00.8 1:32.2 2:01.4 #VALUE!
:28.4 :57.6 1:28.0 1:57.8 #VALUE!
:28.2 :58.2 1:28.4 1:57.4 #VALUE!

"Fred Smith" wrote:

Why can't you work with times? Isn't that what you are looking for -- how
much time it took the horse to run the race?

Even if you sent me a sample, you still haven't said what solution you seek.
As most people don't like dealing with files because of the risk of viruses,
they post examples in their messages. Why is it so difficult to post an
example of what you have, and what you need?

Regards,
Fred.

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

If you have :30.8 in a cell, then it's probably text--not a time (a real
number).



Jesse wrote:

Hi Fred see the sample

Column1 Column2 Column3 Column4 Total
:30.8 :58.8 1:28.4 2:00.0 #VALUE! I use the formula to add
:27.8 :57.2 1:26.2 1:53.6 #VALUE! Sum (a1:a4) = #Value
:31.0 1:00.4 1:29.6 1:58.2 #VALUE! and I get a Value
:32.4 1:02.2 1:31.4 2:00.4 #VALUE!
:30.0 1:00.8 1:32.2 2:01.4 #VALUE!
:28.4 :57.6 1:28.0 1:57.8 #VALUE!
:28.2 :58.2 1:28.4 1:57.4 #VALUE!

"Fred Smith" wrote:

Why can't you work with times? Isn't that what you are looking for -- how
much time it took the horse to run the race?

Even if you sent me a sample, you still haven't said what solution you seek.
As most people don't like dealing with files because of the risk of viruses,
they post examples in their messages. Why is it so difficult to post an
example of what you have, and what you need?

Regards,
Fred.

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








--

Dave Peterson