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