average time

[michelin]

Hi,

I have a problem to count my average time.

I have a special situation. I have a couple of incidents that I need to exclude (incident D1) from counting the average but I still need to see them in my report.

Incident start end difference
V1 00:20:20 00:20:26 00:00:06
V2 14:15:16 14:16:16 00:01:00
D1 15:13:12 15:13:15

what formula should I use for counting the average time (in my case it would be 00:00:33)?

Thank you for any advice!

 

[Madawc]

Count the records. Sum them. Divide sum by count

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[lbass]

Please do not start multiple threads on the same topic.

-LB

 

[michelin]

I know, I'm sorry. I realized that I post it to wrong category and I didn't know how to delete it..