Hi all,

I am currently in the process of creating a lateness report

Example of the data sheet.

Col B = Lateness code ie "Lunch"
Col F = Duration of the lateness ("HH:MM:SS")
Col H = Area where they work

Basically what im after is to work out if the occurance is over 3 minutes to calculate how many (Collum B) but only if the code is "Lunch" & area "Retail".

From my understanding I can't work this out with a single countif because it has more than one criteria?

Thanks in advance for any help