Good Day,

I have a rather large data set that I am working with which includes values that are listed in a minutes/seconds format. The data was pulled from a csv file and is listed in generic text values but I would like to convert the data to be in time value (mm:ss).

For instance, here are 4 data points that I have:

Duration
2:10
1:00
0:45
0:55

*example... the first point is 2 minutes and 10 seconds.

When I attempt to sum up the totals or average them out, I am unable to do so since they are not currently listed as mm:ss values. How can I convert them in excel?

Additionally, I have a rather large data set to work with and will need to put them into a pivot table in order to get the larger total and average (among other key metrics). What value do I need to assign to the column in the pivot table in order to see the figures represented in mm:ss?

Thank you for your time... Your assistance is much appreciated!
jwberg95