Forum Discussion

GeoffreyHarmuth's avatar
GeoffreyHarmuth
Qrew Captain
8 years ago

Number to hours

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
  • DanLadner1's avatar
    DanLadner1
    Qrew Trainee
    8 years ago
    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])
  • ShawnRenn2's avatar
    ShawnRenn2
    Qrew Trainee
    8 years ago
    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!