1 Reply Latest reply on Oct 5, 2018 3:15 PM by Shinichiro Murakami

    How to calculate the monthly average of a nn:ss measure (Running Data)?

    Garrett Dube

      Hey all,

       

      I'm trying to average out my running pace per month. Attached is the workbook I am currently using.

       

      In the first image, the average line per month is based on a measure format and not a time format. In the second image, I have converted the average pace of each run into a time format. Ideally, the average time per month would be calculated from the second image and displayed where the highlighted numbers are in the first image in a time format (mm:ss).

       

      Thanks in advance!