I have a duration/run time field I’m importing, currently stored in Milliseconds. Anybody have a quick formula to help convert that to mm:ss? Thank you.
Duration: Converting Milliseconds to mm:ss?
+29What is the field type of your duration/run time field?
If it is a duration field type, it is stored in seconds. You can adjust the formatting settings for the field type to show the mm:ss format.
If the field is a number field, you can use a formula field to divide by 1000, then set the formatting for the field to duration and set the mm:ss duration format.
If you need to format the number as a string to include in another formula, I’m afraid that is a bit more difficult, but still doable.
This was very helpful. Thank you. I had it stored originally as a single line text, but I just coverted it to a number field. Then, I was able to add a formula field, divide by 1000 and format properly. Works great. Solved. Thank you!
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.