Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |