I want to calculate average of time spent on each task
But while calculating the average i dont want to count those time for average which is taking very long amount of time.
Lets say we have 5 task:
Task 1 takes 500 seconds
Task 2 takes 300 seconds
Task 3 takes 4000 seconds
Task 4 takes 450 seconds
Task 5 takes 500 seconds
If we calculate the average the result will be 1150 seconds.
But i want to eliminate those data from average calculation due to which the average is screwed up (4000 in this example). The reason for this is it may be possible that we don't have enough resource to complete the task at that time and taking longer because we are waiting for that resource.