This seems fairly simple and I'm sure it's been answered, but I can't find anything on it. I've got times listed in one column in AM/PM format and I just need to drop a 1 or 2 in another column depending on the time. I need a 1 for anything between 6:00 AM - 6:00 PM and a 2 for 6:00 PM - 6:00 AM.
Thanks in advance.
Bookmarks