Format of Number of Hours

[AnnieGr]

I believe the formula I have is being accepted by Excel, its not thrown an error. However, I am not sure the format for the hours is causing me a problem. I have to report those orders whereby we hit our SLA of 2hrs and less which is green for good. Over 2hrs is red and not so good. The lady that has filled in the spreadsheet has unfortunately entered the data literally as 1 hour 45 minutes. I have format the cell to show hh:mm which is showing 01:45:00 so that would be green for good. For 2hrs she has entered 2 Hours. With the formatting its changed to 02:00:00. The formula below I have asked excel to return the number of orders that are less than or equal to 2hrs, it returns zero whan I can clearly see on the spreadsheet there are 4

=COUNTIFS('[Generator Daily Data 19.01.2019.xlsx]SUPPLIER TEMPLATE'!$A$11:$A$164, "TYNE AND WEAR", '[Generator Daily Data 19.01.2019.xlsx]SUPPLIER TEMPLATE'!$B$11:$B$164, "RESTORATION", '[Generator Daily Data 19.01.2019.xlsx]SUPPLIER TEMPLATE'!$T$11:$T$164, "<=02:00:00", '[Generator Daily Data 19.01.2019.xlsx]SUPPLIER TEMPLATE'!$T$11:$T$164, "=02:00:00")

Its not throwing an error like my other attempts, and am not sure its the format that is causing the problem or that my formula is wrong?

 

[steve the fish]

Like this?

=COUNTIFS('SUPPLIER TEMPLATE'!$A$11:$A$164,"TYNE AND WEAR",'SUPPLIER TEMPLATE'!$B$11:$B$164,"RESTORATION",'SUPPLIER TEMPLATE'!$T$11:$T$164, "<=02:00:00")

 

[AnnieGr]

I can see what I have done, I have put 02:00:00 in twice!