Coverting seconds, to minutes and seconds

[JaB]

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

 

[Pete_UK]

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