counting cells with time criteria

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

pschar

Here is my dilemma . . .

I have a large amount of data where one column has log in time ( eg -
8:00 AM). I need to figure out the formula that will let me count the
number of cells that are between 8:00 AM and 12:00 PM in that
column?!?!?!


help.


jason
 
jason

XL counts one day as 1, therefore 0800 = 1/3, 1200 = 0.5. Try

=SUM((A1:A1000>1/3)*(A1:A1000<0.5))

if you mean between 0800 & 1200,

=SUM((A1:A1000>=1/3)*(A1:A1000<=0.5))

if you mean 0800 to 1200 inclusive.

NB - array formula ; enter with CTRL+Shift+Enter, *not* plain Enter.

Rgds,
Andy
 
Back
Top