=(162-MOD(162,60))/60 & ":" & MOD(162,60)

"mftr" wrote:

How can I convert a three digit seconds figure to minutes and seconds in a
mm:ss format (i.e. 162 seconds as 2:42)? I can get the right raw number by
dividing by 1440, but that seems to produce an h:mm format, albeit with the
right digits.