Custom field‏ formulas

Home Forums Discussion Forum Custom field‏ formulas

Viewing 1 reply thread
  • Author
    Posts
    • #396175
      Ramil Ganiyev
      Guest

      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

    • #396181

      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

Viewing 1 reply thread
  • You must be logged in to reply to this topic.