Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i calculate what i make in a year into an hour? | Excel Worksheet Functions | |||
Miles Per Hour | Excel Worksheet Functions | |||
Calculate rate per hour | Excel Discussion (Misc queries) | |||
How to use miles per hour and mileage to estimate travel time | Excel Worksheet Functions | |||
Calculate hour and minutes worked each day | New Users to Excel |