From: Nick Gill on
I am using the following formula to obtain the number of calls for a period
of time:
This gives me back an answer (2), from this answer I now need to calculate
the average the call duration from a call duration field not in the original
the cells/columns used in the formula are:
Call!$G:$G=Call Direction
Call!$D:$D=Call Start Time
$I346=StartTime of Period
$F346=EndTime of Period
and the column I wish to get the Average Call Duration from is Call!$B:$B