Calculating average processing time base of conditions in Excel 2010

[lawoffashioninc]

Hello,

I am trying to find the right formula to use in my spreadsheet for work to calculate my specialists processing and average time. I have several columns with large data but every month I need to know the average processing time by for each specialists. I am sure this question has been asked before but I have searched and searched for a possible formula.

I have provided an example of the table below:


[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[TD]R[/TD]
[TD]S[/TD]
[TD]T[/TD]
[TD]U[/TD]
[TD]V[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD]Unique Code[/TD]
[TD]Unique Property[/TD]
[TD]Client Last Name[/TD]
[TD]Client First Name[/TD]
[TD]Assgn. Specialists[/TD]
[TD]Form Type[/TD]
[TD]Date form was logged[/TD]
[TD]Date Packet forward to Specialists[/TD]
[TD]Date packet was received by specialists[/TD]
[TD]Date Packet was Denied[/TD]
[TD]Date of 1st appt[/TD]
[TD]Date of briefing[/TD]
[TD]Total Processing Time to determine eligibility [/TD]
[TD]Total Processing Time to deny [/TD]
[TD]Total Processing time to briefing [/TD]
[TD]Overall Processing times [/TD]
[TD]Average Specialists Processing Time[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]xxxx[/TD]
[TD]xxxxx[/TD]
[TD]Text[/TD]
[TD]Text[/TD]
[TD]Text[/TD]
[TD]Text[/TD]
[TD]m/dd/yy[/TD]
[TD]m/dd/yy[/TD]
[TD]m/dd/yy[/TD]
[TD]m/dd/yy[/TD]
[TD]m/dd/yy[/TD]
[TD]m/dd/yy[/TD]
[TD](=Networkdays G,H)[/TD]
[TD](=Networkdays I,K)[/TD]
[TD](=Networkdays K,L)[/TD]
[TD](=Sum M, N, O)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[neeraj_chow]

I believe this is eaily done by use of pivot tables.
In pivot table dialog, drop specialist field in Row labels and fields with the times be dropped in Values box. Then for each of the values choose average and voila you have got your answer.