Hi,

I am trying to filter a spreadsheet which lists in one column job type, and
in the other column response time (total duration in hh:mm:ss). I have been
trying to figure out a COUNTIF query which would allow me to obtain the
number of jobs which have a job type of 'F' for 'Fault', and which have a
response time of less than 2 hours.

If anyone can help me with this, that would be greatly appreciated.
Thanks