Convert Numeric field into Duration
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'...
Forum Discussion
Hey Mark,
I tried that, and 1777 (seconds) displays as 29:37:00 (HH:MM:SS). I changed the Minutes() formula to Seconds() and that worked. I can't use the rounding formula because I need to be able to specify when to round, instead of just in the exact middle.
------------------------------
Daniel Johnson
------------------------------
I tried that, and 1777 (seconds) displays as 29:37:00 (HH:MM:SS). I changed the Minutes() formula to Seconds() and that worked. I can't use the rounding formula because I need to be able to specify when to round, instead of just in the exact middle.
------------------------------
Daniel Johnson
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendYes, you are correct to use Seconds, that was my error.
As for the rounding, if you are still stuck on that as the famous Kirk Tracy says, "if you can say it we can do it". So if you can say what the rounding rules are then I can help you with the formula.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
As for the rounding, if you are still stuck on that as the famous Kirk Tracy says, "if you can say it we can do it". So if you can say what the rounding rules are then I can help you with the formula.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Hey Mark,
It needs be rounded down for anything ending between 0-19 seconds, and rounded up for anything ending in 20-59 seconds.
------------------------------
Daniel Johnson
------------------------------- MarkShnier__Youtry this formula duration field
var duration RawDuration = Seconds([my input field]);
var duration FloorOfDuration = Floor($Raw Duration, Minutes(1));
var duration ExtraSeconds = $RawDuration - $FloorOfDuration;
$FloorOfDuration
+
If($ExtraSeconds >= Seconds(20),Minutes(1), Minutes(0))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- That worked! Thanks Mark!
------------------------------
Daniel Johnson
------------------------------