Sunday, 08 January 2006 06:23 samaye, Chris BONDE alekhiit: > 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))
Store the two times in two cells A1 and A2, subtract the earlier from the later by a simple =A2-A1, divide the distance by this subtraction result A2-A1 and then again by 24 and you have the speed. (The reason I say to divide again by 24 is that time is internally stored as a fraction of a day, so you are actually dividing by a fraction of a day. So you will get the speed in miles per day and so dividing by 24 gives miles per hour. I just tested this and hope it works for you too.) -- Penguin #395953 resides at http://samvit.org subsisting on SUSE Linux 10.0 with KDE 3.5 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
