Does anyone now how to calculate miles per hour using excel?

  • Thread starter Thread starter RuSLMaN
  • Start date Start date
R

RuSLMaN

If the time is, for example, 1:30:23 (h:mm:ss) and the miles are 30, what
function would you use figure it out?

Thanks for any help,
Russ
 
With the time in A1 and the miles in A2, in A3 enter:

=A2/(24*A1) and format as General
 
Time in A1; miles in B1
Speed = =B1/(A1*24)
The 24 is there to convert time which Excel stores as a fraction of a day to
hours
You may need to format the cell General since the time in A1 may fool Excel
into formatting it Time
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Miles Per Hour 1
Average minutes per mile 7
In Excel, how do I display a leading zero? e.g. 05 for 5 ? 1
Nested Array Formula to Determine Average cost Per Mile in 100 mileincrements 1
Looking for Mileage / MPG Tracking formula 3
how do I convert pace per mile to total time in minutes in excel? 2
Problems with IF statement 4
Calculating time for 3rd shift 4

Back
Top