COUNTIF or not...
Posted by Deirdre on July 24, 2001 7:57 AM
:: pulls out hair ::
I have a colum of times in military format. These times correspond to a product being produced. If a time is enterd, that means a product has been produced.
I wish to count the number of products produced in an hour. I've tried setting up the function =COUNTIF(A2:A91,"<=8:00") which of course does count the Number of instances below and equal to 8:00.
HOWEVER I cannot figure out how to set this up to count the number of instances BETWEEN 7:00 and 8:00. Whenever I try, it returns a value of 0 even though there is faux date entered which would return a number other than 0.
I have uploaded the sheet to a website if it would help you in assisting me.