How to get the average of time values and show on report

dcollard23

Registered User.
Local time
Today, 04:52
Joined
Jun 15, 2009
Messages
87
How do I add time and then average it. I want to show it on a report. Example I have 05:28, 02:05, 00:00, 1:10, 36:48, 00:49, 1:24, 00:46 which is adding up to 48:30 (48 minutes and 30 seconds). When I try to average this on a report I am getting 3:06:04. The 06:04 is correct but why am I getting a 3 at the beginning when I do =Avg([SSR SLA]) in the control source area on the report.

Thanking you in advance for your help.
Elaine:)
 
why is there a 0 in front of:
Code:
05:28
and not:
Code:
1:10
???

could that be the issue? I doubt it, but I did notice it. ;)
 
is the prioblem that your TIME isnt what you think it is ? Access and XL seem to convert these to TIMES in the day as opposed to length of time between two events. As far as i can tell - to average minutes then you would need to so this in a NUMBER format as minutes and have your queries/reports convert them to a time in hours if needs be.

this all may be complete poppycock - but thought worth a write.
 
@the_net_2.0, just forgot to put a 0 when typin.
@reddwarf, thanks for replying.
 
Last edited:
Have a great Christmas and try this tastey snack fresh from Spent Geezer Association
 

Attachments

Users who are viewing this thread

Back
Top Bottom