Could someone please help me to write a new formula. Currently I have this:
=SUMPRODUCT(('Timing Plan'!$V$8:$V$1032)*('Timing Plan'!$P$8:$P$1032=$C13)*('Timing Plan'!$H$8:$H$1032<BX$7)*('Timing Plan'!$I$8:$I$1032>=BX$7+1))
$V$8:$V$1032 = average required hours
$P$8:$P$1032=$C13 = Person responsible
$H$8:$H$1032<BX$7 = start date of task
!$I$8:$I$1032>=BX$7+1) = task deadline
This averages out the allocated hours to a ask from the start to end date. There is a column M that allows you to enter the hours completed to date. I would like the hours to readjust over the remaining days if for example more hours were consumed one week or if less hours were consumed another week.
Bookmarks