Forum Discussion

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

Re: Convert Numeric field into Duration

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

5 Replies

DanielJohnson2
Qrew Trainee
4 years ago
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
------------------------------
- MarkShnier__You
  Qrew Legend
  4 years ago
  Yes, 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
  ------------------------------
  - DanielJohnson2
    Qrew Trainee
    4 years ago
    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
    ------------------------------