2009/11/19 Hylton Conacher (ZR1HPC) <[email protected]> > 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. > > As I said, if you entered the time into A1 as, using your current example, 2947 (meaning 29 minutes and 47 seconds) then the minutes are int(A1/100) and the seconds are mod(A1;100).
Sorry but I thought it was obvious that if you entered it as .2947 instead then you'd need int(A1*10000/100) and mod(A1*10000;100). The second is required but the first can, of course, be simplified to int(A1*100). To express this as a decimal of an hour we want minutes/60 + seconds/3600 so the whole thing becomes =int(A1*100)/60 + mod(A1*10000;100)/3600 Just format the columns to have as many decimal places as you need. -- Harold Fuchs London, England Please reply *only* to [email protected]
