5 Replies Latest reply: Sep 30, 2010 6:51 PM by Karl Pover RSS

    Calculating Average Times in a Chart Table

      Hi Gurus:

      Please bail me out once again. I have a table:

       

      Employee

      StartTime

      EndTime

      Bubba

      8/15/10 08:00

      8/16/10 10:20

      Bubba

      8/18/10 12:00

      8/20/10 12:00

      Hazel

      8/08/10 09:30

      8/08/10 10:15



       

      We want to get the average, by person of time to complete each task. So, Bubba's average is (26:20 + 48:00) / 2 = 37:10. Hazel is simply 00:45.

      Resulting table should be:

       

      Employee

      Average (in hours)

      Bubba

      37:10

      Hazel

      00:45



       

      My Pivot Table current expression is:

       

      avg(aggr(sum(EndTime - StartTime), Employee)), which is obviously not working. Any suggestions are greatly appreciated.