Using time in a formula
 

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?

Using time in a formula
 

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 =----

Using time in a formula
 

You don't need the N() function. Just format the answer as General or
Number.
--
David Biddulph

"Vergel Adriano" wrote in message
...
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
=----