Patrick,
Multiply the elapsed time by 24 to get time in hours. Assuming C3 holds the
elapsed time and C4 holds the distance travelled in miles.
=N(C4/(C3*24))
"Patrick C. Simonds" wrote in message
...
I need to calculate Miles Per Hour. I hav a worksheet where a start and end
time is entered. Then I subtract End time from Start time to get the
elapsed time:
14:50 - 14:25 which returns 0:25 (or 25 minutes)
How can I now use the returned result to divide distance by time?
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----