Change a seconds value into mm:ss

  • Thread starter Thread starter guilbj2
  • Start date Start date
G

guilbj2

I have a bunch of values in seconds (534.49 seconds, 649.87 seconds..
and so on) and would like to display them in minutes and seconds. I
there an easy way to do the conversion
 
Divide by 86400 (put 86400 in an empty cell, copy it, select the
values and do edit>paste special and select divide, format custom as [mm]:ss
 
Back
Top