View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
time conversion[_2_] time conversion[_2_] is offline
external usenet poster
 
Posts: 13
Default Average in a Pivot Table

I have a report that is looking for average times for surgical cases.

SURGEON PROCEDURE TIME AVERAGE

Dr Smith Appendix 92 min 79.25 min
85 min
75 min
65 min

Dr. Jones Gall Bladder 62 min 66.22 min
58 min
69 min
91 min
51 min
Would anyone know how I could find the average for thousands of these
types of procedures?? Ihave all the data....Surgeon/Procedure/Case
Time......but I can't figure out how to get the averages for each surgeon per
procedure.