Skip to main content
Question

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

  • July 26, 2017
  • 0 replies
  • 94 views

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? 

  • Quickbase Alumni
  • July 26, 2017
Your formula-duration field should just be [Time]/[Distance] then set the value display from Smart Units to MM:SS

  • Author
  • Quickbase Alumni
  • July 27, 2017
Thanks