Hello,
Let's say that I have 3 columns of data: Client, Time, Zone
What I need is to have a formula in the Zone column that looks at the time in the Time column and returns one of 3 values.
Zone 1 = any time between 8:00am and 11:00am
Zone 2 = any time between 11:01am and 2:00pm
Zone 3 = any time between 2:01pm and 5:00pm
So if data in Time column = 8:31 am then the value in Zone column should = 1
I hope this makes sense without a file attached. Thanks in advance!
Bookmarks