Sum and Averages in Report

[CoachPhil]

Hi Troops,

I have a Report, driven from a query that gives me employees, the number of transactions in a time period, and the number of seconds in total.

I have summed and averaged the total transactions-no problem.
The total seconds I was able to convert to hh:nn:ss. But..............
I need the average transaction time. No can do so far.
Should the total seconds converted to time be done in the query? And Should we be able to divide the total time by transactions?

Coach Phil

 

[gemma-the-husky]

in this case, i would be inclined to store time elapsed as a long, not as a time - assuming the elapsed time values in seconds are generally relatively small - then you can sum and average without worrying about time formats

 

[CoachPhil]

Gemma,

You are a genius, worked like a charm. Thanks for the refocus on the real issue.

CoachPhil