how do you count cells with a time criteria??

  • Thread starter Thread starter pschar
  • Start date Start date
P

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??
 
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")
 
Back
Top