Counting Occurances of Time

[EliA]

I'm trying to count the number of times a particular hour appears on my
spreadsheet. For example I have a lists of times ranging from 7am to 9pm
(hh:mm:ss, military time) and would like a breakdown of howmay rows I have
containing the hour of "7", then "8" and so on until all hours are
acccounted. Can you help

 

[JimS]

Post to the Excel community.

 

[Klatuu]

"Counting Occurances of Time"

As few as we insignificant creatures here on Earth know, time has occured
only once. <g>
This is an Excel question and you may get a better answer there, but I might
suggest you look at the CountIf function.

Have a good .......time.