Forum Discussion

Molalenge's avatar
Molalenge
Copper Contributor
Apr 09, 2024

Task variance: planned vs elapsed time with no activities

I'm trying to create a column that automatically calculates the elapsed time of one task's start date and finish date. For instance, one task starts on 04/01/24 and ends on 04/30/24 with 22 working days in the calendar. As of 4/09/24, no progress has been made, so the % work completed shows "0" and the status "Late." Thus, can one calculate the days planned, 22 days, and seven days elapsed? Thanks. Teshome

 

 

1 Reply

  • John-project's avatar
    John-project
    Silver Contributor

    Molalenge

    I don't quite understand how such a metric would be of any value but here's a formula you can use in a custom Duration field, assuming a normal 8 hour work day.

    Duration1=DateDiff("d",[Start],[Current Date])*480

     

    John

Resources