Hi!
I need help with a formula that I need to make. I created an On-Time Performance sheet that we use to see if our drivers our operating within schedule. The problem is we are allowing a 2 minute difference either way to count as on-time. The formula I have now will not work for this since I need a 2 minute difference. The formula I am using is
=COUNTIF(B296:B326,"=4:35 AM")
How do I add the range of 4:33 am to 4:35 am in this calculation.