Quick Base Discussions

Expand all | Collapse all

How to convert Duration to numeric ?

  • 1.  How to convert Duration to numeric ?

    Bronze
    Contributor
    Posted 07-25-2017 17:59
    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? 


  • 2.  RE: How to convert Duration to numeric ?

    Bronze
    Contributor
    Posted 07-25-2017 18:02
    Have you tried using the ToNumber([Duration_Field_A]) in the calculated column?


  • 3.  RE: How to convert Duration to numeric ?

    Bronze
    Contributor
    Posted 07-25-2017 18:12
    Yes, ToNumber only has text and boolean as argument. Doesn't work. 


  • 4.  RE: How to convert Duration to numeric ?

    Bronze
    Contributor
    Posted 07-25-2017 18:20
    Ah you're right. I tried a duration field, entered 5, returned 5 days. then in a formula numeric field used ToText() and it returned 120. Assuming you want 5 to return?


  • 5.  RE: How to convert Duration to numeric ?

    Bronze
    Contributor
    Posted 07-25-2017 18:22
    If so ToDays() returned 5 in the formula numeric field.