Excel: convert seconds to minutes

An alternative to maintain your time data integrity ie. if you change the format
would be to use the following formula

=YourCell/(60*60*24)

The division by 60 * 60 * 24 is neccessary
because Excel stores all dates as integers and all times as decimal fractions. Excel takes your value as been a single day or 24 Hour
period eg enter 2 = 2days = 2 24hr periods =2*60*60*24 secs
Times are stored as decimal numbers between .0 and .99999,
where .0 is 00:00:00 and .99999 is 23:59:59

and then format your cells like this;

In the "Format cells" Dialog
Select Custom
In the "Type:" box
Type in "mm:ss"

This should give you the results as Minutes Seconds
Use the format painter to copy the custom formats to
your data range.