Home |
Search |
Today's Posts |
#1
|
|||
|
|||
A formula to express distance per minute ....
Hi all,
Given time in mm:ss and distance in general decimal form (eg 5.5 miles) is there an effective way to write a formula to express the distance per minute? I have tried a few things - to no avail .... Also, I have a particular excell cell formatted as mm:ss - however I note I always have to input data into cell in hh:mm:ss format? If I exclude 'hh' (which is always 00) I get a meaningless data representation .... Is this right? thx, Don- |
#2
|
|||
|
|||
After you divide the distance by time divide that by 1440. Since time is
really "part days" you need to convert it to minutes by dividing by 24*60. .... Is this right? Yes. Number formats (excluding "text" which is not a number format) are not input templates. They affect how a number is displayed not how an entry is interpreted when it is entered. -- Jim "Don" wrote in message ... | Hi all, | Given time in mm:ss and distance in general decimal form (eg 5.5 miles) is | there an effective way to write a formula to express the distance per minute? | I have tried a few things - to no avail .... | Also, I have a particular excell cell formatted as mm:ss - however I note I | always have to input data into cell in hh:mm:ss format? If I exclude 'hh' | (which is always 00) I get a meaningless data representation .... Is this | right? | thx, | Don- |
#3
|
|||
|
|||
Jim is correct. I'll just add that you may need to format the cell
containing the final distance-per-minute value. Excel may automatically put it in hour:min format. In that case you'll need to change the Number format of the cell to either General, or to Number (with as many decimals places as you want -- your option). Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
How to express $A:$A with formula | Excel Worksheet Functions | |||
Time and distance formula | Excel Worksheet Functions |