AnsweredAssumed Answered

Calculating Average Speed in MPH

Question asked by Lex262 on Oct 10, 2008
Latest reply on Feb 15, 2012 by disabled_JackRodgers


Calculating Average Speed in MPH


Taking a simple speed calculation, I can't seem to get FMP 7 to come up with the same result I can get in Excel.




20 Miles Distance Traveled

1 Hour to travel that distance


I'm trying to get FMP to come to 20 as the result. 20/1 - doesn't seem difficult unless time is formatted as "TIME". 1:00:00 - which I need in this application.


Setting it to "TIME" and my resulting figure as Average speed comes out .00555555555 MPH Which is obviously wrong without the *24. With the *24 it's .0002314814814815


I can't seem to find any reference that will help me in this area. Anyone have an idea on this? I'm sure it's just trying to relate hours/minutes/seconds in FMP differently than Excel, but for the life of me I can't figure it out.