identify three times of the day

I need to calculate wait times in the morning, afternoon and evening.  I have appointment times from 8:00 AM – 8:00 PM and need to break the time up to reflect “Morning” (8a-11:59a), “Afternoon” (12P – 3:59P) and “evening” (4P – 8P).  I’m sure there’s an IF THEN that I just can’t figure out.

By: Jillian

Leave a Reply

Your email address will not be published. Required fields are marked *