Calculating remaining task duration without considering %complete

Name: Excel: From Raw Data to Actionable Insights. Mastering Pivot Tables and Power Pivot (1 of 3)
Start: 2023-05-10T12:00:00-05:00
End: 2023-05-10T13:00:00-05:00
Location: Live Virtual Conference

This topic has 4 replies, 2 voices, and was last updated 6 years, 11 months ago by TQ.

Viewing 3 reply threads

Author

Posts
- 04/19/2016 at 6:08 am #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
- 04/19/2016 at 8:34 am #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…
  - 04/19/2016 at 10:45 am #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.
- 04/19/2016 at 1:07 pm #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])))
- 04/20/2016 at 5:01 am #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.
Author

Posts