Calculating remaining task duration without considering %complete

Home Forums Discussion Forum Calculating remaining task duration without considering %complete

Viewing 3 reply threads
  • Author
    Posts
    • #392833
      TQ
      Guest

      I have an urgent qs. I have a task with duration as 10 days. I need to calculate the remaining duration (without taking into account) percent completion as days pass by. For eg : task1 starts on 1st april and ends on 10th april and has a duration of 10 days. Now i want to create a custome field which will show me the remaining duration on 2nd april as 9days. Please guide. Thanks

    • #392844
      Larry Christofaro
      Participant

      TQ, try using the out of box Actual Duration and Remaining Duration columns. These should give you want you are looking for. Hope that works…

      • #392872
        TQ
        Guest

        Actually larry i did, but its not giving me the desired result. I tried using the datediff function with Current date and Finish date as variables but that too didnt work. A little help here would really be appreciated.

    • #392888
      Tom Boyle
      Guest

      TQ,
      You’ll want to use the ProjDateDiff function rather than datediff. Placing the following formula in a custom duration field should do the trick:
      IIf([Current Date]>[Finish],0,IIf([Current Date]<[Start],[Duration],ProjDateDiff([Current Date],[Finish])))

    • #392955
      TQ
      Guest

      Tom, i tried using the formula but it gives me the same original duration of the task and not the remaining duration.

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