Change a seconds value into mm:ss

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
 
P

Peo Sjoblom

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
 
Top