Hello,
I'm wanting to automatically fill a cell depending on the date and time of two other cells.
These are the statements I'm trying to formulate into one cell:
1. Mon-Thurs, 08:01-17:00 = "A"
2. Mon-Thurs, 17:01-08:00 = "B"
3. Fri, 08:01-13:00 = "A"
4. Fri, 13:01 - Sun, 17:00 = "C"
I currently have a column with the date in, a column which reads the date and returns the day name (ie, A3=04/09/2017, A4=Mon) and a column with the time.
Any help much appreciated!
Many thanks
Bookmarks