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

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

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

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

=A2/(24*A1) and format as General
--
Gary''s Student - gsnu200771


"RuSLMaN" wrote:

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

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

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"RuSLMaN" wrote in message
...
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