Hi

I have a report field which looks at response times. We want to find the  average time from request received to reponse given. Both Request Time and Response Given time are in Date time format. I have worked out the time differences and the averages but there are occasions where a request is made but  reponse is not given for various reasons therefore there some requests times with blanks for Response Given time and it would appear that the average calculation is counting these blanks for the divide by part of the average.

How can I supress these blanks so they are not counted in the average

Hope that makes some vague kind of sense!