This my first question so I hope I have not broken any forum rules.
I am trying to create a Solutions Architect Task Board and need to create a formula that keeps a running total of the days/hours a solution is placed on hold:
When the “on hold” is selected in the “status column”; the task is moved to the On Hold Item and the “On hold Date” is set to today’s date. Once “In Progress” is selected in the “Status column” the task is moved back to the Task column and the “Hold End Date” is set to today’s date (which takes the task off hold) and we now have ‘hold start and finish dates’. The problem is that I need to track the total task hours less the time spent on hold, this is hard for me to work out as any single task can be placed on hold several times throughout the solutions life cycle.
I need a column / formula that keeps adding the total days / hours each time a project is put on and taken off Hold. I then need to deduct this total from the total project hours to get an accurate total of just the hours that were productive (all hours less the hours on hold).
Hope I have not confused the issue?
Look forward to your response.
Thank you in advance,