AVG on time on a Report Group

L

Lambi000

I have records with a time field in it and have a report that groups the
records by date and attempts to average the time. It works fine (although it
comes out decimal instead of minutes) on some records and not on others. I
have checked this out manually and it surprises me that my results are so
inconsistent.

I must be doing something wrong. The Average field reads:

=Avg([FirstOfTime waiting])

I really do want to average the times but don't know how.

Thanks.
 
D

Duane Hookom

Dates and times are numeric values. 6:00 AM is actually stored as 0.25. You
can try set the format property of the text box to display the format you
want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top