Question on the countif function and times
Why aren't your ranges the same?
--
__________________________________
HTH
Bob
"MTSkibum" wrote in message
...
I need to count all the times between 12:01 am and 12:10 am in a collumn, i
have been messing around with variations of the formula, i have even tried
to
use cells to hold 12:01 and 12:10, but that didnt work either.
=COUNTIF(G1:G500,"12:01")-COUNTIF(G1:G238,"12:10")
with this equation i get a 0 value
=COUNTIF(G1:G500,"12:01")-COUNTIF(G1:G238,"<12:10")
with this formula i get an answer of -238, ie the negative value of the
number of total entries
thanks for any help
|