[residentEvil]

I need formula help; and as I know this board has a group of some of the smartest (and smart ass) people I know...

I need a formula for figuring out MPH (miles per hour) dealing with: fraction of miles and minutes/seconds.

For example:

1.25 miles in 11 minutes and 23 seconds.

What is that in MPH? And what does the formula look like for paper/pencil...as well as how would it look as a formula in a spreadsheet cell?

I'm having, well, a hard time even doing that by hand. I must be "missing" something that simplifies it. I found a website that does it for me...but I want that knowledge

[P]

Easiest is to convert the time into hours with decimals (ie. hour=min/60+sec/3600) and then just do distance/hour.

[residentEvil]

Originally Posted by P 

Easiest is to convert the time into hours with decimals (ie. hour=min/60+sec/3600) and then just do distance/hour.

aaaaah. see, that is the "trick" i needed. what to do with the time. that was it?

i feel pretty damn stupid. good thing i have rugged good looks and make people laugh. HA!

thanks.

[turtle777]

If you want it easier than that: Wolfram Alpha:

1.25 miles in 11 min and 23 sec in MPH - Wolfram|Alpha

-t

[residentEvil]

Originally Posted by turtle777 

If you want it easier than that: Wolfram Alpha:

1.25 miles in 11 min and 23 sec in MPH - Wolfram|Alpha

-t

Like I posted: I already found websites to do it. What I wanted was how to do it myself in my own spreadsheets...and that was already answered.

MacNN never fails to deliver...

[turtle777]

Originally Posted by residentEvil 

Like I posted: I already found websites to do it. What I wanted was how to do it myself in my own spreadsheets...and that was already answered.

Man, I had to read your post three times to see that piece of information

-t