Case is this:
Each task is estimated certain number of hours to complete. The actual number of hours consumed to complete the task is calculated.
Now I want to find out the variance between estimated time and actual time. I get #### when variance is negative value.
<colgroup><col span="3"></colgroup><tbody>
</tbody>
What is the formula to calculate variance and to show the negative value in hours?
Each task is estimated certain number of hours to complete. The actual number of hours consumed to complete the task is calculated.
Now I want to find out the variance between estimated time and actual time. I get #### when variance is negative value.
Estimate | Actual | Variance +/- |
2:00:00 | 8:00:00 | ########## |
4:00:00 | 8:30:00 | ########## |
8:00:00 | 6:00:00 | 2:00:00 |
16:00:00 | 3:00:00 | 13:00:00 |
32:00:00 | 1:00:00 | 31:00:00 |
<colgroup><col span="3"></colgroup><tbody>
</tbody>
What is the formula to calculate variance and to show the negative value in hours?