Countif for finding a Time input
Good One!!
"T. Valko" wrote in message
...
Can't find the right combination of using logic
= and < within the countif formula...
Like this...
=COUNTIF(A1:A20,"="&TIME(6,0,0))-COUNTIF(A1:A20,"="&TIME(7,0,0))
Might be easier to use this...
=SUMPRODUCT(--(HOUR(A1:A20)=6))
--
Biff
Microsoft Excel MVP
"Meebers" wrote in message
g.com...
Got a big long column D containing times formatted as i.e. 13:30. I am
trying to do a countif function for finding the count of inputs between 6
am and 6:59 am, and 7am and 7:59 etc. Can't find the right combination
of using logic = and < within the countif formula... appreciate any
help here..
|