Averaging Times in column

T

Tracey Powell

I have a report that is something like this:

User Reason Call Time Call Length Call Hold
9
1 10:00 3:15 :30
1 10:15 7:00 :10
4 10:05 5:20 :15
10
1 10:00 3:15 :30
1 10:15 7:00 :10
4 10:05 5:20 :15

I need to average each user on each reason. I keep getting errors when I try =Avg([Call Length]) and I have NO clue how to use DAvg because I get errors on it, too.

Can someone help me?
 
J

John Vinson

I have a report that is something like this:

User Reason Call Time Call Length Call Hold
9
1 10:00 3:15 :30
1 10:15 7:00 :10
4 10:05 5:20 :15
10
1 10:00 3:15 :30
1 10:15 7:00 :10
4 10:05 5:20 :15

I need to average each user on each reason. I keep getting errors when I try =Avg([Call Length]) and I have NO clue how to use DAvg because I get errors on it, too.

Can someone help me?
Click to expand...

Date/Time fields aren't really suitable for storing durations: a
Date/Time is stored internally as a count of days and fractions of a
day since midnight, December 30, 1899.

I'd suggest storing your durations in Long Integer seconds - i.e. a
call that lasts 3 minutes 15 seconds would be stored as 195. You can
use expressions or simple VBA functions to convert back and forth to
nn:ss format.
 
Top