Skip to main content
Question

Number to hours

  • October 31, 2017
  • 0 replies
  • 22 views
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
      • Registered
      • October 31, 2017
      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
      • Registered
      • October 31, 2017
      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!
      Terms & ConditionsAccessibility statement