Jen,

Simply, instead of dividing by the worker count (5), divide the final sum by the weighted employee
count (4.25).

HTH,
Bernie
MS Excel MVP


"Jen_T" wrote in message
...
I have a worksheet where I average the turnaround time per month per
employee, than take all the averages and get an average for the group for
that month.
The situation I have now is a new employee does the work 25% of the time and
the employee average is of course is lower than the reamining employess since
she only works on the process 25 % of the time. How do I obtain accurate
average turnaround time for all five employees with one only processing 25%
of the work ?