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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating seconds into mm:ss 4
calculate average given minutes and seconds 4
How do I convert time as text 'mm:ss to time value in Excel 5
format numbers as mm:ss 3
How can I convert or format an elapsed time to show mm:ss 4
Formatting time 6
convert to mm:ss to just seconds 1
Time format conversion 7

Back
Top