LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
RC RC is offline
external usenet poster
 
Posts: 39
Default Distance/Time calculation

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time - Distance plot... Mark[_11_] Excel Discussion (Misc queries) 3 May 2nd 10 06:30 PM
Minimum Distance Calculation using Array and Geographical Coordinates geobatman Excel Discussion (Misc queries) 1 June 9th 06 10:49 PM
calculate time/distance KJO Excel Programming 3 April 20th 05 09:53 PM
time/distance calculation KJO Excel Worksheet Functions 1 April 20th 05 09:13 PM
Time and distance formula drumnotme118 Excel Worksheet Functions 2 November 20th 04 06:22 AM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"