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

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
 
G

Gary''s Student

With the time in A1 and the miles in A2, in A3 enter:

=A2/(24*A1) and format as General
 
B

Bernard Liengme

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

Calculate end date and time 1
In Excel, how do I display a leading zero? e.g. 05 for 5 ? 1
Miles Per Hour 1
A couple questions BEFORE using Office 365 0
Excel Countif Function - Calculating Between Two Sets of Values 3
help w indirect and index,match 3
Calculating time for 3rd shift 4
Average formula 4

Top