On second thought: try dividing the 25% employee's value by 4 if it is a time or other duration
value (since it should take them 4 times longer) before averaging it.

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 ?