Dennis Marks wrote:
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-time1)/3600))
Much. Time values are stored as a fraction of a day. So if you subtract
two time values you have a decimal number which is also a fraction of a
day.
MPH = distance / ((time1 - time2) * 24)
--
Rod
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
