Isn't there a way I can change the decimal place to put minutes in as decimals? Like 1 minute 30 seconds entered as 1.5 minutes.
Yea, if you want to put the numbers in as a fraction of an hour, just remember this.
1hour 15minutes would be 1.25, and 1hour 35minutes would be 1.5833
That is what I was trying to get away from. I just wanted to put in the actual ride time, and let Bill Gates do the math. If you put it in as a decimal you will still have to divide it by 24, and format the cell to [h]:mm in order to get your actual ride time. If you don’t do this you will have time in base 10, and no mater what, the metric system does not work for time.
What I did was the inverse of this, I put time in as hour and minutes, and had brother Bill convert that to a fraction, then I added all the fractions, then I had Bill turn the fractions back into time. ~ What a pain in the @r$$.