Hi everyone,
I'm trying to make a spreadsheet with my running times:
Three columns with Date, Location and Time.
I am trying to have the time display as mm:ss - for example, I want it to display 58:27 (fifty eight minutes and twenty seven seconds). My goal is to have the data to create graphs showing my times.
I have tried formatting the cells, but when I do this, it displays strange. Below is a screenshot of how typing in 58:27 displays. See, it makes no sense!!
Can anyone help?
I'm trying to make a spreadsheet with my running times:
Three columns with Date, Location and Time.
I am trying to have the time display as mm:ss - for example, I want it to display 58:27 (fifty eight minutes and twenty seven seconds). My goal is to have the data to create graphs showing my times.
I have tried formatting the cells, but when I do this, it displays strange. Below is a screenshot of how typing in 58:27 displays. See, it makes no sense!!
Can anyone help?