Convert Numeric field into Duration

Question

Hi All,We're porting in data from an API on phone calls and one of the fields is the length of the call. That information comes to us in seconds. From there, how can I get it to show in MM:SS? It's being sent into a numeric field at the moment because I guess the default for the duration field is hours? Right now I've got a numeric field showing 1777, and I'd like a field that shows 29:37. In actuality, I need that field to round down from 00:19, and round up from 00:20, but I figured I'd just right that into an if statement once I was able to get the numbers looking right.------------------------------Daniel Johnson------------------------------

MarkShnierYou · Answer

You can create a new Formula Duration field with a formula of Minutes([my import field]).

If you want to round to the nearest Minute, then you can use the Round formula

Round(Minutes([my import field]), Minutes(1))

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community