I have sheet with columns listed as distance and time. An example of the
values in these columns are distance 5.0 km and the time column is
00:52:30.15 what type of formula would I would I need for a value in a
kilometre per hour column. TIA

--

Regards
Michael Koerner

=N(A2/(B2*24))

where A2 is the distance, B2 the time.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Michael Koerner" wrote in message
...
I have sheet with columns listed as distance and time. An example of the
values in these columns are distance 5.0 km and the time column is
00:52:30.15 what type of formula would I would I need for a value in a
kilometre per hour column. TIA

--

Regards
Michael Koerner

Bob;

It does, and thank you very much

--

Regards
Michael Koerner


"Bob Phillips" wrote in message
...
=N(A2/(B2*24))

where A2 is the distance, B2 the time.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Michael Koerner" wrote in message
...
I have sheet with columns listed as distance and time. An example of the
values in these columns are distance 5.0 km and the time column is
00:52:30.15 what type of formula would I would I need for a value in a
kilometre per hour column. TIA

--

Regards
Michael Koerner

Speed = distance moved / time taken
The distance moved is A2-A1
Time taken is B2-B1
Speed is =(A2-A1)/(B2-B1) and the parentheses are needed to make sure Excel
does the subtractions before the division

If the series of measurements are for a non-accelerating object maybe your
task (and this does sound like homework!) is to fit the data to a straight
line. Make a chart and add a trendline; then look in Help to lean about the
SLOPE function

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Michael Koerner" wrote in message
...
I have sheet with columns listed as distance and time. An example of the
values in these columns are distance 5.0 km and the time column is
00:52:30.15 what type of formula would I would I need for a value in a
kilometre per hour column. TIA

--

Regards
Michael Koerner

Thanks Bernard. A little to far gone to be a student. well into my 7th
decade <g

--

Regards
Michael Koerner


"Bernard Liengme" wrote in message
...
Speed = distance moved / time taken
The distance moved is A2-A1
Time taken is B2-B1
Speed is =(A2-A1)/(B2-B1) and the parentheses are needed to make sure Excel
does the subtractions before the division

If the series of measurements are for a non-accelerating object maybe your
task (and this does sound like homework!) is to fit the data to a straight
line. Make a chart and add a trendline; then look in Help to lean about the
SLOPE function

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Michael Koerner" wrote in message
...
I have sheet with columns listed as distance and time. An example of the
values in these columns are distance 5.0 km and the time column is
00:52:30.15 what type of formula would I would I need for a value in a
kilometre per hour column. TIA

--

Regards
Michael Koerner

Sorry. I just started to seventh decade last month!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Michael Koerner" wrote in message
...
Thanks Bernard. A little to far gone to be a student. well into my 7th
decade <g

--

Regards
Michael Koerner


"Bernard Liengme" wrote in message
...
Speed = distance moved / time taken
The distance moved is A2-A1
Time taken is B2-B1
Speed is =(A2-A1)/(B2-B1) and the parentheses are needed to make sure
Excel
does the subtractions before the division

If the series of measurements are for a non-accelerating object maybe your
task (and this does sound like homework!) is to fit the data to a straight
line. Make a chart and add a trendline; then look in Help to lean about
the
SLOPE function

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Michael Koerner" wrote in message
...
I have sheet with columns listed as distance and time. An example of the
values in these columns are distance 5.0 km and the time column is
00:52:30.15 what type of formula would I would I need for a value in a
kilometre per hour column. TIA

--

Regards
Michael Koerner

Youngster <g Also on the MVP list. Like to post in the public ng just in
case what I ask is causing problems for others.

--

Regards
Michael Koerner


"Bernard Liengme" wrote in message
...
Sorry. I just started to seventh decade last month!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Michael Koerner" wrote in message
...
Thanks Bernard. A little to far gone to be a student. well into my 7th
decade <g

--

Regards
Michael Koerner


"Bernard Liengme" wrote in message
...
Speed = distance moved / time taken
The distance moved is A2-A1
Time taken is B2-B1
Speed is =(A2-A1)/(B2-B1) and the parentheses are needed to make sure
Excel
does the subtractions before the division

If the series of measurements are for a non-accelerating object maybe your
task (and this does sound like homework!) is to fit the data to a straight
line. Make a chart and add a trendline; then look in Help to lean about
the
SLOPE function

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Michael Koerner" wrote in message
...
I have sheet with columns listed as distance and time. An example of the
values in these columns are distance 5.0 km and the time column is
00:52:30.15 what type of formula would I would I need for a value in a
kilometre per hour column. TIA

--

Regards
Michael Koerner

On Mon, 9 Mar 2009 07:35:43 -0400, "Michael Koerner" wrote:

I have sheet with columns listed as distance and time. An example of the
values in these columns are distance 5.0 km and the time column is
00:52:30.15 what type of formula would I would I need for a value in a
kilometre per hour column. TIA

If 00:52:30.15 is elapsed time in hrs:minutes:seconds then
elapsed time in hours = left(elapsed time,2) + mid(elapsed time,4,2)/60 +
mid(elapsed time,7,5)/120
and
Kilometers per hour =Kilometers/elapsed time in hours

5.0/(00 + 52/60 + 30.15/120) = 4.47 Km/Hr

Chuck

Chuck;

Thanks, will try it out.
--

Regards
Michael Koerner


"Chuck" wrote in message
...
On Mon, 9 Mar 2009 07:35:43 -0400, "Michael Koerner"
wrote:

I have sheet with columns listed as distance and time. An example of the
values in these columns are distance 5.0 km and the time column is
00:52:30.15 what type of formula would I would I need for a value in a
kilometre per hour column. TIA

If 00:52:30.15 is elapsed time in hrs:minutes:seconds then
elapsed time in hours = left(elapsed time,2) + mid(elapsed time,4,2)/60 +
mid(elapsed time,7,5)/120
and
Kilometers per hour =Kilometers/elapsed time in hours

5.0/(00 + 52/60 + 30.15/120) = 4.47 Km/Hr

Chuck

On Mon, 9 Mar 2009 12:30:30 -0400, "Michael Koerner" wrote:

Chuck;

Thanks, will try it out.

When you try it and it doesn't work, the seconds should be divided by 3600 not
120.
--
Chuck

That is exactly what happened. thank you very much.

--

Regards
Michael Koerner


"Chuck" wrote in message
...
On Mon, 9 Mar 2009 12:30:30 -0400, "Michael Koerner"
wrote:

Chuck;

Thanks, will try it out.

When you try it and it doesn't work, the seconds should be divided by 3600
not
120.
--
Chuck

Chuck tried your formula, and came up with a #DIV/0

C23 = 5.14
D23 = 00:53:23.44

Here is how I inserted it according to your earlier post.

=C23/LEFT(D23,2)+MID(D23,4,2)/60+MID(D23,7,5)/3600

--

Regards
Michael Koerner


"Chuck" wrote in message
...
On Mon, 9 Mar 2009 12:30:30 -0400, "Michael Koerner"
wrote:

Chuck;

Thanks, will try it out.

When you try it and it doesn't work, the seconds should be divided by 3600
not
120.
--
Chuck

What are you trying to calculate?

If you are trying to calculate speed given a distance and a time then use:

=B3/(B4*24)

Where B3 is distance and B4 is time.


"Michael Koerner" wrote in message
...
Chuck tried your formula, and came up with a #DIV/0

C23 = 5.14
D23 = 00:53:23.44

Here is how I inserted it according to your earlier post.

=C23/LEFT(D23,2)+MID(D23,4,2)/60+MID(D23,7,5)/3600

--

Regards
Michael Koerner


"Chuck" wrote in message
...
On Mon, 9 Mar 2009 12:30:30 -0400, "Michael Koerner"
wrote:

Chuck;

Thanks, will try it out.

When you try it and it doesn't work, the seconds should be divided by 3600
not
120.
--
Chuck

On Sat, 14 Mar 2009 13:19:44 -0400, "Michael Koerner" wrote:

Chuck tried your formula, and came up with a #DIV/0

C23 = 5.14
D23 = 00:53:23.44

Here is how I inserted it according to your earlier post.

=C23/LEFT(D23,2)+MID(D23,4,2)/60+MID(D23,7,5)/3600

--

Regards
Michael Koerner


Sorry 'bout that. Try:
=C23/(LEFT(D23,2)+MID(D23,4,2)/60+MID(D23,7,5)/3600)
Note the parentheses after the / and after the 3600
--
Chuck