I need to find a formula or method to find cells that fall between time ranges:
7 am - 1 am, 1 am - 7 am, 12 pm - 1 pm. It would be nice to label it 7 am - 1 am "morning", 1 am - 7 am "grave shift", and 12 - 1pm "lunch"

Do you know a way? PLEASE HELP! I have googled for hours on this.


sample data:
HOUR SCHEDULE DATE/TIME
11:00:00 PM 8/31/2012 11:00:00 PM
1:50:00 AM 9/1/2012 1:50:00 AM
1:50:00 AM 9/1/2012 1:50:00 AM
2:10:00 AM 9/1/2012 2:10:00 AM
2:50:00 AM 9/1/2012 2:50:00 AM
8:00:00 AM 9/1/2012 8:00:00 AM
8:40:00 AM 9/1/2012 8:40:00 AM
8:40:00 AM 9/1/2012 8:40:00 AM
8:55:00 AM 9/1/2012 8:55:00 AM
10:25:00 AM 9/1/2012 10:25:00 AM
11:00:00 AM 9/1/2012 11:00:00 AM
11:35:00 AM 9/1/2012 11:35:00 AM
2:30:00 PM 9/1/2012 2:30:00 PM