Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time - Distance plot... | Excel Discussion (Misc queries) | |||
Minimum Distance Calculation using Array and Geographical Coordinates | Excel Discussion (Misc queries) | |||
calculate time/distance | Excel Programming | |||
time/distance calculation | Excel Worksheet Functions | |||
Time and distance formula | Excel Worksheet Functions |