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?
Question
Convert time captured in minutes to standard format as minutes and seconds
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.