Forum Discussion
Molalenge
Apr 09, 2024Copper Contributor
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
Sort By
- John-projectSilver Contributor
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