I have two colums of data, a time is say A1 and a unit name in A2, 150 or so rows of this.
Currently I'm doing a count if statement on the time portion.
=COUNTIFS(B250:B417,">=17:00",B250:B417,"<=17:59")
This gives me the count for that time period, I have one for the 24 hours in a day...