# Number to hours

• 0
• Question
• Updated 2 years ago
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
• 1,980 Points

Posted 2 years ago

• 0
• 1,558 Points
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!