average- time formula

[michelin]

Hi,

I need a help to write a formula.

I have following data:

Incident time difference
A 00:02:00
B 00:03:00
C 00:02:00
D 00:06:00

Incidents B and D are highlighter incidents. I need them to stay in my report but I don't want to count them against the average. My average would be then 00:02:00. This is just an example. In real I have 375 incidents and 46 of those incidents don't meet requirements. I still need them to be in my report but I don't want to count them against the average.

Any help is appreciated!

 

[SkipVought]

hi,

What is the logic that you want to apply to this instance? This is also referred to as a Business Case.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[michelin]

my highlighted incidents are car incidents (B, D). Incident A is a bike incident. Incident C is blank (doesn't have a type). So I said that if an incident is a car incident then highlight the results. But I don't want this incident to be count in an average. Does this make a sense?