Afternoon All

I am attempting to workout a quick and easy way of counting some results
that are displayed in an excel spreedsheet. All of the results are date and
time stamped, and also have a column that showes the state of the outcome
[WA, NSW, QLD and so on]. What i am wanting to do is get a count basised on
the state column for every hour?

Can anyone assist? Cheers TJ