Here is a Picture of my Spreadsheet. What i want to do is Have a call time average. I am running into the problem where my calculation for the Call time is making the result as 0:00:00 if there is no start or end time. So when i try to get an average it will Include all 25 fields.
1) Either have it so that The call time is blank when there is no start and end time.
2) Or the Call time Average does not include all the Zeros
1) Either have it so that The call time is blank when there is no start and end time.
2) Or the Call time Average does not include all the Zeros