Feet/Second - Miles/Hour
by Geetarman1217 on 07/12/03 at 04:45:14

If I have the following data where the first column is feet and the second column is seconds:

38      0.00
58      0.05
58      0.10
58      0.15
58      0.20
77      0.25
77      0.30
96      0.35
96      0.40
115      0.45
115      0.50
135      0.55
135      0.60
154      0.65
154      0.70
173      0.75
193      0.80
212      0.85
212      0.90
231      0.95
251      1.00

What would be a formula to use for a third column to show Miles per Hour?

Thank you

Re: Feet/Second - Miles/Hour
by Robert Fogt on 07/12/03 at 05:21:23

feet / 5280 = miles
seconds / 3600 = hours

feet/second * 5280/3600 = miles/hour

Your fist time, 0 seconds, isn't possible, but for the others:

58/0.05 * 5280/3600 = 1701.3333 miles/hour
58/0.10 * 5280/3600 = 850.66667 miles/hour

and so on..

Go Back | Archive Index