Loading...
Quick Links

Reply To: Adding the total of two columns, to display total in 3rd column

Home Forums Discussion Adding the total of two columns, to display total in 3rd column Reply To: Adding the total of two columns, to display total in 3rd column

#344329

– Open the Task Usage view and apply the Work table; the Remaining column (Remaining Work) will show the total remaining hours.
– Set the period of the timescale on the time-phased table (right part) to weeks; right click here and add the Actual Work to the horizontal detail.
– Now, in the time-phased table, any week period that shows scheduled work hours (Work) but no actual hours (Actual Work) represents the remaining hours; and the sum of all these periods are equal to the total value shown in the Remaining column on the left.
– Project recalculates Work, when you update Actual Work and Remaining Work by using the formula Work = Actual Work + Remaining Work.