how do you count cells with a time criteria??

[pschar]

I need to get a count of cells in a column based off of a time criteria.
The colum is a in "TIME" format ( 8:00 AM, 12:00 PM, etc).

I need to get a count of cells that are between 8:00 AM and 12 PM . .
what formula would I use??

 

[David McRitchie]

Hi ...,

=countif(A2:A20,">=08:00")-countif(A2:A20,">12:00")

if you want it under row 20 you can use
A21: =countif(A$2:OFFSET(A21,-1,0),">=08:00")-countif(A$2:OFFSET(A21,-1,0),">12:00")

 

[pschar]

worked like a charm . . .thanks so much.

 

[purple people eater]

use the countif function