convert seconds into minutes

[adee]

Hi
i am not able to convert secons into minutes.

ex: 224 seconds as 4 minutes , roundeingfunction is only roundeing up to 1
place after decimal.

Pls help any one.

B.Regds
adee

 

[Allen Browne]

Try:
=[Seconds] \ 60 & Format([Seconds] Mod 60, "\:00")

Explanation:
http://allenbrowne.com/casu-13.html