Forum Discussion
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 d...
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