This content has been marked as final. Show 5 replies
Please bail me out once again. I have a table:
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:
Average (in hours)
My Pivot Table current expression is:
avg(aggr(sum(EndTime - StartTime), Employee)), which is obviously not working. Any suggestions are greatly appreciated.