Home › Forums › Discussion Forum › Custom field formulas
Hello Everybody
I would like to kindly ask you to help me with below question which relates to custom field formulas.
I have already created formula in custom field for Text24 which calculates required hours according to numbers on Text23.
Text24 = ([Text23]/25)*44
I have also got digits which contains letter M (meter) in Text23. Is there any options to make formula where it will calculate digits with letter M?
example Text24 = ([Text23 (M)]/60)*44 or Text23 contains “M” /60*44???
Here is the another example
TEXT 23 TEXT24
358 630.08 hours
60.63M #ERROR
1840 3238.4 hours
Your help and support are really appreciated
Pls try using Val([Text23]).
Background:
The Val function listed under the category Conversion, can be used to convert any valid string expression containing
numbers to a numerical value; its syntax is Val(string). The function strips any whitespace character (i.e., blanks,
tabs, and linefeed characters) from the string passed as parameter; for example, Val(“1234 56”) returns the numeric
value 123456. The Val function recognizes only the period as the decimal separator.
Source: https://www.msptips.com/Formulas/_Built-in%20Functions%20in%20Project%20Category.html