Discussions

Expand all | Collapse all

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

  • 1.  Convert time captured in minutes to standard format as minutes and seconds

    Posted 07-26-2017 18:51
    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? 


  • 2.  RE: Convert time captured in minutes to standard format as minutes and seconds

    Posted 07-26-2017 19:49
    Your formula-duration field should just be [Time]/[Distance] then set the value display from Smart Units to MM:SS


  • 3.  RE: Convert time captured in minutes to standard format as minutes and seconds

    Posted 07-26-2017 20:11
    Thanks