Using time in a formula

  • Thread starter Thread starter Patrick C. Simonds
  • Start date Start date
P

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?
 
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))
 
Back
Top