Convert time captured in minutes to standard format as minutes and seconds
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?
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?
