This had me stumped for a while until I figured it out. Seems simple enough, but man, my mind chugged along for a good 20 mins before I got it.

The problem: show mm:ss as mm.00.

For example, 1 minute 15 seconds would be 1.25.

The solution? If your time in mm:ss format is in cell A1:

=A1*(24*60)

Then, format that cell to ‘general’ and there you have it- the solution to a problem none of you will ever have! It keeps me busy, though.