Convert time captured in minutes to standard format as minutes and seconds

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hello, I have a field in which I calculated time. Unit  of this time field is smart units and I have a field called pace which shoes number of minutes taken to cover a certain distance. It is expressed by the formula as follows: (ToMinutes([time]/[distance])). 

This pace formula gives results in decimal form such as: 3.5 minutes. I need to show the result as 3 minutes and 30 seconds or 3:30
 Can anyone suggest me any idea on how to accomplish the task or change my formula? 
Photo of Raj Helaiya

Raj Helaiya

  • 1,298 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
Your formula-duration field should just be [Time]/[Distance] then set the value display from Smart Units to MM:SS
Photo of Raj Helaiya

Raj Helaiya

  • 1,298 Points 1k badge 2x thumb
Thanks