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

[dcollard23]

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

 

[the_net_2.0]

why is there a 0 in front of:

05:28

and not:

1:10

???

could that be the issue? I doubt it, but I did notice it.

 

[reddwarf]

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.

 

[dcollard23]

@the_net_2.0, just forgot to put a 0 when typin.
@reddwarf, thanks for replying.

 

[SpentGeezer]

Have a great Christmas and try this tastey snack fresh from Spent Geezer Association