How to calculate average time/duration

[vitality97]

Hi,

I hv a access mdb which contains one column as "duration", data format as hh:mm:ss, e.g. 00:02:20 - 2 mins 20secs.

How could I calulate the average of the duration?
like sum of all duration fields / the ttl no of records.

Pls help. Thank you!

 

[Jon K]

You can build a Totals Query based on the table and use the Avg aggregate function on the Duration field to arrive at the average duration. It is possible because date/time data type is internally a double precision number.

See the query in the attached database. The AvgOfDuration field in the query has been formatted as hh:nn:ss in the Field Properties sheet. The query also contains an expression for calculating the numeric average of NumberOfSeconds.
.