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 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:




1 + = 5