Converting to minutes and seconds

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there

Does anyone know how to convert a number into minutes and seconds in the
following format - mm:ss

Many thanks
 
To expand - I would like to do this when the number is the result of a MAX
formula. I have tried using the custom mm:ss format but this just gives me
the result 00:00 for some reason.
 
At the moment, the figure expressed is in seconds but displayed just as a
general number.
 
XL stores times as fractional days, so if you want a true XL time,
you'll need to divide by 24*60*60:

A1: 23
A2: =A1/86400 ===> 0:00:23
 

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
Converting time (raw) into ss:mm 1
calculate average given minutes and seconds 4
Time format conversion 7
convert time 2
Working with duration data 3
Excel Convert Datetime Stamp to HH and MM Worked 7
How do I convert time as text 'mm:ss to time value in Excel 5

Back
Top