Please help - How to search and count...

  • Thread starter Thread starter mon0307
  • Start date Start date
If you can separate the date from the time as it is entered, you can use
a simple IF formula. =IF(B1>10,IF(B1<11,1,0),0) This will produce a 1
for every entry between 10 and 11 and will produce a 0 for all other
entries. Don't know if that will help, but I hope it does.
 
I have another problem, i don't know how to separate the date from the
time. I'm a newbie in dealing with excel formulas... please help!
 
Hi mon0307,

Although I can't see your attachment I'll take a stab at
it anyhow!

=SUMPRODUCT((A29:A34>=TIME(10,0,0))*(A29:A34<=TIME
(11,0,0)))

This will count all entries in the range that fall between
10:00 and 11:00 AM.

Adjust the range to suit.

P.S. - It's really not a good idea to post with
attachments. People like myself who use the web interface
don't get them (which is a good thing) and most if not all
the others using a newreader won't open them.

Biff
 
Back
Top