Please help - How to search and count...

[mon0307]

i've attached a picture of my problem. I want to know what is the
formula so that I can count only the entries that has the time between
10 and 11am... Please help. thanks again for the tips you can give me.

File Attached: http://www.exceltip.com/forum/attachment.php?postid=282708 (excel.jpg)

 

[sho-nuff]

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.

 

[mon0307]

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!

 

[Biff]

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