Trying to find an average time (from a list of times)

[homer2002]

Hi

I have a list of records (all one table so nothing serious)



say for example I have a list of times in a field

field 1 = primary key (autonumber)
field 2 = a general date field

pk TimeRecordAdded
1 20/05/03 16:58:32
2 20/05/03 17:02:51
3 20/05/03 17:05:41
4 20/05/03 17:10:00
5 20/05/03 17:15:11


what I need to be able do do (on a report)
if to total up these times and get an average
for example
THE AVERAGE TIME IT TOOK TO ADD EACH RECORD WAS 00:02:52

can anyone help me

 

[mark curtis]

have a look at attached for starting point