Wally,

For example, to find times between 9 aand 10 AM:

=SUMPRODUCT((A2:G8-(INT(A2:G8))TIMEVALUE("9:00:00"))*(A2:G8-(INT(A2:G8))=TIMEVALUE("10:00:00")))

--
HTH,
Bernie
MS Excel MVP


"wally" wrote in message
...
In a workbook, dates and times for events are kept in columns, each column
representing the number times the events have occurred for the item in that
row. In this workbook the item in the row would be an address.

I need to break down the entered data by the hour such as 09:00, 10:00,
11:00, etc. The following is an example of the entries:

5/24 12:57 7/26 08:28
5/17 02:02 6/14 01:33 9/20 03:50
4/18 17:52 9/8 16:15 10/30 20:51 11/11 08:56
7/3 21:16
1/4 08:12 3/13 06:05 8/7 00:11 9/9 03:33

Thank you for your suggestions.