Skip to main content
Question

How to convert Duration to numeric ?

  • July 25, 2017
  • 0 replies
  • 171 views
I have a field duration which collects data in minutes using smart units. I want to convert this duration to numeric field so I can use it in a calculated column to compute pace? 

I tried using the function ToNumber but it doesnt validate the argument. Is there any other way? 

    • ChuckGrigsby
    • Quickbase Alumni
    • July 25, 2017
    Have you tried using the ToNumber([Duration_Field_A]) in the calculated column?
    • RajHelaiya
    • Author
    • Quickbase Alumni
    • July 25, 2017
    Yes, ToNumber only has text and boolean as argument. Doesn't work. 
    Terms & ConditionsAccessibility statement