Using time in a formula

[Patrick C. Simonds]

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?

 

[Vergel Adriano]

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

 

[David Biddulph]

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