Is there a simpler way of computing mph given two time values and the distance?
=distance/(HOUR(time2-time1)+(MINUTE(time2-time1)/60)+(SECOND(time2-ti me1)/3600)) -- Dennis Marks Dennis: It depends upon what data you have? Generally, miles per hour is considered distance travelled divided by the time required to travel that distance. However, if the time period is great, I would consider the mph as average mph. There are other formulae, depending upon the data available to calculate. Chris --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
