If your data is in cols A&B, then insert a helper column. In C1 enter
=HOUR(A1) and copy down. You will see:

time count hour
0:01:05 10 0
0:02:10 20 0
1:05:00 999 1
2:00:01 9 2
Then construct a Pivot Table using sumof count in the data field and hour
in the row field.
--
Gary''s Student


"RD975" wrote:

Have spreadsheet that contains column with timestamp and another with count.
Would like to summarize total counts based on hourly interval. Sample
spreadsheet:
00:01:05 10
00:02:10 20
01:05:00 999
02:00:01 9
.
.
.
Would like to total all counts for HOUR(0) "30 another for HOUR(1) "999"
another for HOUR(2) "9" etc.

Thanks