Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Duration: Converting Milliseconds to mm:ss?

Topic Labels: Formulas
481 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

2 Replies 2

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.

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!