Hi Bob, Your solution is valid but it doesn't accomplish what I am looking for. I'll send you a calc spreadsheet so you can play.
It does sort of help however entering the time value is a mission with the :'s. I'd much rather enter it as a decimal fraction ie 0.2947 being 29 minutes and 47 seconds. Also how would you calculate the speed as being a function of Distance / time? Sorry, still looking for a solution. Hylton --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org