Do you mean something along the lines of

=SUMPRODUCT(--(G$2:$G$1000=TIME(7,30,0)),--(G$2:$G$1000<TIME(8,30,0)))

etc.

Best to put the comparison times in cells and use say

=SUMPRODUCT(--($G$2:$G$1000=A1),--($G$2:$G$1000<B1))

which can then be copied easily

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mohitmahajan"
wrote in message
...

I have several tabs for different dates with data in it. Colomn G
contains the time in format 13:30:30.

For my project, I require to know the number of data points in various
time series, pls see below.

7:30:00 8:30:00
8:30:00 9:30:00
9:30:00 10:30:00
10:30:00 11:30:00
11:30:00 12:30:00
12:30:00 13:30:00
13:30:00 14:30:00
14:30:00 15:30:00
15:30:00 16:00:00

I tried countif and if function but could not come up with the results,
PLS HELP. If I have to do it manually then I am dead......


--
mohitmahajan
------------------------------------------------------------------------
mohitmahajan's Profile:
http://www.excelforum.com/member.php...fo&userid=8130
View this thread: http://www.excelforum.com/showthread...hreadid=492678