changing seconds to minutes

[klemczak]

I'm looking for a formula which will convert seconds (e.g. 128 seconds) to minutes (2:08).

[comment]

"2:08" is not minutes - it's two minutes and eight seconds, displayed in time format. GetAsTime ( numberOfSeconds ) will do this for you.

Or, if this is a calculation field, just set the result type to Time.

[klemczak]

Thanks for the help. However it does not seem to be working. The result is still the same as the input - just seconds.

The Field (calculation) is called 'Seconds A'. Would you have a calculation which involves it?

[comment]

What is your input? Do you have a Number field where you enter a number of seconds - or do you calculate the number of seconds from other data?