Convert a formula duration result into a numeric value

Please post your current formula.

14 what? Minutes? Hours? Days? Weeks?

The time is in hours. It is generated from a duration calculation based on timestamp:

[Stamp OUT]-[Stamp IN]

Which generates the duration in hours to the field [Period Duration]. That field is used in the following formula:

If([Period Duration]>14,"Yes",null)

Which then generates the error below:

The expression [Period Duration] on the left hand side of the operator ">" is of type duration while the expression 14 on the right hand side is of type number. The operator ">" cannot be used with these types of expressions.

Ok. No problem. Because it�s s duration, it needs to know the units.

If([Period Duration]>hours(14,)"Yes")

Perfect, Thanks!

After trying that it works as an argument, but it will not display the text "yes". It says expecting duration but found text. I can work with the result but it's not quite 100%. (I moved the comma outside the bracket as it didn't seem to like that)

If you want the result to be Text, change the field type to formula Text.

I only want a text output if the duration is greater than 14 hours. When I try to use the > symbol in a text formula field I get a an error due to the > operator. Can't be applied on types text, duration.

actually I get the error either way although the formula works insofar as it returns a number from a duration which is what I really need. I can live without the text.

I�m confused as to what result you are looking for. I think that you have never stated that in words.