Duration: Converting Milliseconds to mm:ss?

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.

What 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.

image

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.

1 Like

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!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.