As an analyst you have a dataset that has some data on how long does it take for participants to complete a race. The data is in seconds. How do you convert that into minutes?
There are 2 steps to do that.
Step 1: Convert the seconds to minutes by dividing the cell by 24*60*60
Step 2: Change the format to Minutes: Seconds by clicking CTRL + 1 and then selecting the format
See the video below on how to do that:
