January 9, 2021
December 7, 2016
There are good articles in this site about date and time in Excel, how to work with them and so forth. Have a look here.
Excel Date and Time - Everything you need to know (myonlinetraininghub.com)
Anyway, some examples here.
I have put in some dummy data in cells B2:B7 in form of time values as seen in below picture.
The formula shown has ; as separators, you probably need to use , instead.
=COUNTIFS(B2:B7,">=01:00 am",B2:B7,"<12:00 pm")
As you are only interested in the hours, you can of course only state the hours as criteria, like this.
=COUNTIFS(B2:B7,">=01 am",B2:B7,"<12 pm")