Number to hours

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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
Photo of Geoffrey

Geoffrey

  • 1,730 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Dan

Dan

  • 1,176 Points 1k badge 2x thumb
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])
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!