Calculating running time from weight of footwear

[spikelovesmetal]

Hello,

I'm trying to make a table or chart which can show how much a person's running time will change with different weights of footwear. Ideally, I'd like to be able to enter a theoretical weight (in g or kg) and come up with a time in mm:ss or even just straight seconds.

An example:

A person wearing trainers that weigh 415g took 11m50s to run a mile and a half.
The same person wearing boots that weigh 959g took 12m40 to run the same mile and a half route.

I have those two as physical measurements, but need a way of showing how fast the person could run with a theoretical weight of shoes (disregarding how feasible the shoes actually are for running, e.g. lightweight sandals versus heavier snow boots). The distance would always be constant at a mile and a half (2414 metres).

Does anyone have any suggestions? I've tried dividing the time by the weight and vice versa but don't seem to get a good answer. Thanks in advance!

 

[shg]

If you assumed the function was linear,

	A​	B​	C​
1​	Wgt​	Time​	​
2​	415​	0:11:50​
3​	959​	0:12:40​
4​
5​	0​	0:11:12​	B5: =FORECAST(A5, $B$2:$B$3, $A$2:$A$3)
6​	10,000​	0:26:31​

 

[spikelovesmetal]

Thank you, that's a great help! I've been trying to use TREND without much success. I haven't come across FORECAST before - a new toy to play with!

Thanks again

 

[shg]

You're welcome.