AVG on time on a Report Group

  • Thread starter Thread starter Lambi000
  • Start date Start date
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.
 
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.
 
Back
Top