Struggling with IFERROR, Conversions and general equating.

Hello on the spreadsheet posted you will see I have a cardio, resistance and bodyweight tables and a calculations page.

1.On the CARDIOEX table I would like it so that I could write in either of the GPS co-ordinates columns (Km or Mi) and have them automatically convert to the other so that I can have both bits of information. also in the time section whenever I enter a time (45 mins for example) it always tries to put it in a date and time format whatever I do.

2. I would then like it to convert the distance and time in to pace (time/distance) for both Km and miles in the respective boxes without div/0 errors in unfilled boxes.

I couldn't wrap my head around those so this one is truly defeating me.

3. I would like to log the amount of calories burned for particular exercises.

That requires Calories (Kcal) = METS x weight (kg) x time (hours)

a)METS - The respective exercises MET value can be found on the calculations sheet.

b) I would like my weight to be the weight that is logged for the date (or nearest to that date) that is logged on personal details sheet

Thanks.

C) some METS values work purely on time some on pace and time you will see this in the cardio table.


Please let me know if you need more info.