I want to set out a spreadsheet to keep track exercise mileage for bike riding, but I'm not sure how I'd go about it. My bike computer measures in metres, which isn't an issue. I've looked online for a formula that would allow me to convert that to miles/kms in separate columns (I know that'd be 2 different formulae) but it's got me stumped (I hate excel, I had to use it at school and I've forgotten everything I used to know unfortunately). I'd like the average MPH as well but that's not a major issue to work out by hand, I'd just rather let a computer do that
I know how to set it out basically (it'll be sorted by "Week Starting" then I'll have my week total at the bottom of each week, that part is easy), but the convert one has got me stuck.
Thanks in advance, guys.