Coverting seconds, to minutes and seconds

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

Guest

Good morning

I was wondering if anyone had a formula that would convert a total number of
seconds to minutes and seconds.

For example, converting the number 151 to 2:31 (2 minutes and 31 seconds).
The numbers I need converting will always be of low value so I will never
need to include a figure for hours.

Thanks
 
Assuming your seconds are in A1, enter this formula in B1:

=A1/60/60/24

and format the cell as Custom [m]:ss

Hope this helps.

Pete
 
Back
Top