Sum of Time

[Lambi000]

I created a report which shows time lapsed between an order entered and the
order worked on. I used a query to minus one from the other and I get the
correct time, which shows on the report.

However, when I use =AVG([Time Waiting]) in the footer of the report to get
the average of [Time Waiting], it shows up as a decimal instead of hours and
minutes. AND when I do a sum of the times, I get a number that's way below
what the times should add up to.

I.E. I have 6:49, 4:05, 12:34, 14:40, 12:49, and 12:49 summing up to
2.65923611112521 hours and averaging 10:38 hours. What am I doing wrong?

Thanks

 

[Jeff Boyce]

It all starts with the data ... "how" to do this depends on "what" structure
your data is in.

What are the data types of the underlying field(s) you use to do the
calculation? What's being stored in them?

Are you converting the time difference to Integer or ...?

By the way, if you are storing "6:49" to mean minutes:seconds (?or
hours:minutes?) (?? or ????!), and you are actually storing it as "6:49",
Access doesn't know how to parse that.

Again, it all starts with the data!

Regards

Jeff Boyce
Microsoft Office/Access MVP