How to calculate work done for a given date or period of time

Question

Hi, i have data regarding project stages, work completed , milestones, number of hours, for different projects over departments.

How to calculate work done for a given date or period of time?

Answer 1

Hi,

Follow these steps:

As per you question since you have work completed and milestones for every stage.

1. Convert the work completed into %.

2. Then calculate the work completed in row wise.

3. Add a new column to show the completed % from sum of all the other stages values.

4. The new column contains the % of total across row.

Hope this helps you.