custom fields with formulas

Home Forums Microsoft Project Discussion Forum custom fields with formulas

Viewing 3 reply threads
  • Author
    Posts
    • #402199
      gian luca
      Guest

      Hi, please can someone help me:
      I inserted some columns using formulas to calculate specific parameters useful for my plan.
      For example in my work is important to understand eur/kilos for a project of steel manufacturing, I put in formula “cost/number” and it works correctly.
      I made the same for another parameter which is productivity kilos/hours manufactured, I used a number/duration and it works but I don’t understand which number Project is calculating for to me.
      Perhaps I don’t understand the exact meaning of the column “Duration”?
      Thanks in advance for your support

      Gian Luca

    • #402208
      Avatar photoLarry Christofaro
      Participant

      Gian, try thinking of duration in minutes by default in a formula and see if that help understand your results. Please respond with what you figure out. Thanks…

    • #402215
      Gian Luca
      Guest

      Yes! you’re right! The software shows into the cells “Hours” but the calculation works with “minutes” by default.
      Thanks
      Gian Luca

    • #402216
      Avatar photoLarry Christofaro
      Participant

      You are very welcome, and glad it helped…

Viewing 3 reply threads
  • You must be logged in to reply to this topic.