Sum of time values

[wolfert]

Hello,

I am creating a query in Access 97 and I would like to summarize a time field. E.g. [Duration] = 00:04:03

I I sum this field in the query, I get all mixed up values like 0,67 in stead of 1:65:03

Any suggestions?

Thanks in advance,
Patrick Wolfert

 

[jjob]

A guess - as I had a problem adding times in Excel. Adding time may basically use Modulus 24/60 etc (or whatever is used for times) so that adding is equivalent to advancing a clock by the appropriate amount. My timesheet software in excel would add hours as though time was elapsing rather than totalling the hourse worked in a week, in the end I wrote my own functions to sum/total times.

 

[wolfert]

Thanks.
I already figured it out.
I used the Datediff function to get a difference between the values and multiplied with 24 or 60 to get days / secs.