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