Average of time makes me crazy?!!11111111111111

[Pietro]

I have a Stopwatch that counts the time :

the format of time of this stopwatch looks like this : 00:00:00:00

I want to make a column on my query to count the AVERAGE of the total
duration,but I get an error message because the format of this stop watch is
strange ,do you have any solution for this problem ?How can i get this
average ?
Can i extract a part of the stopwatch (mm:ss) time on an unbound box so that
it may be easier for me to get the average ?if yes,how can i extract it ?

Regards

 

[Douglas J. Steele]

The biggest reason for your problem is that there is no Time data type in
Access, and the Date type used instead is intending as a timestamp: a
specific point in time, as opposed to a duration.

Best approach would be to figure out what granularity you need (second?
tenths of seconds? hundredths of seconds?) and store the duration in a Long
Integer, where 1 represents whatever unit you decided above. Do your
calculations on that Long Integer field, then write your own function to
format it as 00:00:00:00