Excel help

[Jesse]

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

 

[Fred Smith]

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]

Thanks Fred for this info
yes my question is how to remove the colons?

 

[Fred Smith]

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]

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 (e-mail address removed)

 

[Gord Dibben]

What I do with something like this is use Data>Import External Data>New 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

 

[Fred Smith]

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]

Hi Gord

just what I need.
Thanks.

What I do with something like this is use Data>Import External Data>New 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

 

[Jesse]

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!

 

[Dave Peterson]

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