Help for a newbie

Hi guys,

First: thanks for taking time to help me out!

My problem, I have 3 columns:

day Time Temperature
1 53 61
1 153 62
1 253 65
1 353 67
1 453 69
etc

Which contains temperature data, for each hour, of each day for a given month.

I want to find out the following:
Between the times 00:00:00 and 7:59:59 how many times is the temperature read in one of the following ranges.

120/124
115/119
110/114
105/109
100/104
95/99
90/94
85/89
80/84
75/79
70/74
65/69
60/64
55/59
50/54
45/49
40/44
35/39
30/34
25/29

Then i want to do this again between, 8:00:00 and 15:59:59 and finally for 16:00:00 and 23:59:59.

In order to make this easier, I set up a column at the end which tests what time range we are in:

=IF(B5<800,1,IF(B5<1600,2,IF(B5<2400,3,0)))

It gives:
1 for 00:00:00 and 07:59:59
2 for 08:00:00 and 15:59:59
3 for 16:00:00 and 23:59:59

So Now, I just need to look at this end column and see what value it is:

Once we have the value I want it to sum up the times the temperature occurs within each range.

Thanks