Countif forumla question with time, please help!

So I'm creating an employee schedule for my office and I need to make sure I have the proper floor coverage. So lets say on Monday I have 5 guys working 9:00 -5:00 and 4 guys working from 2:00 to 10:00. I would like a forumla that would look at all of the staff on monday and countif they were working day or night shift.

Please let me know if u need more info.

Thanks

Not sure in what format your data entry is.
I suggest you enter the data in the following way and then its easy:
- 1st column should have name or ID or whatever
- 2nd column should be shift start time (ex: 09:00 or 14:00)
- 3rd column should be shift end time (ex: 05:00 or 22:00)
keep the 2nd and 3rd column in time format

and then enter the following formula wherever you want the summary:
=COUNTIF(D2:D8,"09:00") for no. of guys in dayshift
=COUNTIF(D2:D8,"14:00") for no. of guys in nightshift

what if I have a bunch of different shifts that start before noon. I would all of them count as morning shifts. Such as 8am, 9am, 10am. Can I do it as a lesser or greater than time, and when u do that does the value have to be set in military time???

Thanks