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.
Simplest to use 2 COUNTIFs
You could use a single SUMPRODUCT (or COUNTIFS for those using XL2007+) but if using a version pre XL2007 I'd opt for the above myself.
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks