 |
 |
Math/Spreadsheet help
|
|
|
|
|
Professional Poster
Join Date: Jan 2000
Location: Detroit
Status:
Offline
|
|
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 
|
|
|
| |
|
|
|
|
|
|
|
Moderator  Join Date: Apr 2000
Location: Gothenburg, Sweden
Status:
Offline
|
|
Easiest is to convert the time into hours with decimals (ie. hour=min/60+sec/3600) and then just do distance/hour.
|
|
The new Mac Pro has up to 30 MB of cache inside the processor itself. That's more than the HD in my first Mac. Somehow I'm still running out of space.
|
| |
|
|
|
|
|
|
|
Professional Poster
Join Date: Jan 2000
Location: Detroit
Status:
Offline
|
|
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.
|
|
|
| |
|
|
|
|
|
|
|
Clinically Insane
Join Date: Jun 2001
Location: planning a comeback !
Status:
Offline
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
Professional Poster
Join Date: Jan 2000
Location: Detroit
Status:
Offline
|
|
Originally Posted by turtle777
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...
|
|
|
| |
|
|
|
|
|
|
|
Clinically Insane
Join Date: Jun 2001
Location: planning a comeback !
Status:
Offline
|
|
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
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
 
|
|
|
Forum Rules
|
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|
Top