Distance/Time calculation

G

Guest

I have a table where I have columns for Distance in Miles, Distance in Yards,
Release Time and Time Taken (in hours and minutes).
I also have a form with the same (plus other) data linked to the table.

When the Distance (eg. 10miles) and Time Taken (eg. 1hr 30mins) are entered
on the form, I want the distance in yards to be calculated and the speed in
Yds/min calculated and both entered in the respective cells in the table.

Question - what formulae do I use and exactly where do I insert the code.
 
B

Bob Phillips

Assuming distance in miles in A1, time taken in B1, distance in yards is

=A1*1760

and if this is in C1, then speed in Yds/min is

=C1/(B1*1440)



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time, Distance, Speed 14
Calculating Distance in MIles 8
IF Function for Football stats 1
Calculating speed 3
hot to calculate peaks of an "irregular" sine wave 2
sub for calculating distance via post code / variable range. 7
multiple distances versus lowest time for a specific distance 1
XL: ping mapquest or googlemaps to get driving time + distance? 5

Top