Quick Base Discussions

Expand all | Collapse all

Number to hours

  • 1.  Number to hours

    Bronze
    Contributor
    Posted 10-31-2017 07:29
    I have a simple Numeric formula field that calculates the sum of 2 other fields.

    How do I convert this "calculated number" into a field that displays hours?  I have tried the following:

    [Field 1] = 10
    [Field 2] = 2
    [Field 3] = [field 1]* [Field 2] = 20

    [Field 4] = Hours([Field3])

    Problem: Now field 4 formula is not pulling through anything


  • 2.  RE: Number to hours

     
    Posted 10-31-2017 11:42
    That works for me--is Field 4 set as a Formula - Duration field?

    You could also cut out a step by doing this:
    hours([Field 1]*[Field 2])


  • 3.  RE: Number to hours

    Posted 10-31-2017 13:41
    There are a few ways to do this, and if your formula isn't firing a value, it's either an issue with a mismatch of value types, (ex time vs simple numeric) or an issue with your formula syntax Without seeing the field properties for 1-3, it's hard to diagnose the issue with the formula, but the end result your after is a duration type formula field.

    I agree with Dan however, The only use I can see for the 4th field is to "convert" the unit of measure to the duration type you want, when it might be easier to change the format of fields 1 and 2 to return a duration value instead, which would make Dan's formula correct.

    Hope this helps!