On 2002-09-05 10:24, SteveG wrote:
Is there a way that if I have a timestamp of 12:33pm I can change it with a formula to a shift?
1st Shift= 0800-1600
2nd Shift= 1600-2400
3rd Shift= 0000-0800
Thanks, Steve
On 2002-09-05 11:28, SteveG wrote:
12:33pm would fall into 1st shift because it is between 8:00am and 4:00pm.
And when I said timestamp, I just meant that I have a column named TIME and it holds all the times of day that particular records were made. And I would like a formula that translates it to another column that I created for the shift data. Either shift 1, 2 or 3 depending on what time is in the TIME column for that record.
Thanks, Steve