Loading...
Quick Links

Calculating remaining task duration without considering %complete

Home Forums Discussion Calculating remaining task duration without considering %complete

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #392833 Reply
    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 Reply
    Larry ChristofaroLarry 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 Reply
    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 Reply
    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 Reply
    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 5 posts - 1 through 5 (of 5 total)
Reply To: Calculating remaining task duration without considering %complete
Your information: