November 4, 201015 yr Newbies I'm looking for a formula which will convert seconds (e.g. 128 seconds) to minutes (2:08).
November 4, 201015 yr "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.
November 5, 201015 yr Author Newbies 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?
November 5, 201015 yr 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?
Create an account or sign in to comment