To display minutes and seconds in the format mm:ss:
- Select the cells containing the minutes and seconds data.
- Right-click and select "Format Cells".
- In the "Number" tab, select "Custom" from the Category list.
- In the "Type" field, enter "mm:ss" and click "OK".
To calculate the average of the minutes and seconds data:
- Select the cell where you want to display the average.
- Type "" and then select the cells containing the minutes and seconds data.
- Type "" and press Enter.
This will calculate the average of the minutes and seconds data and display it in the selected cell. To format the result as mm:ss, you can apply the custom number format as described above.