Thanks Rick. This worked very well.
-Misty

Rick Rothstein (MVP - VB) wrote:
Hello All, Please help me to do this.
I have a spreadsheet containing a column of dates called EntryDates, I
[quoted text clipped - 8 lines]
If between 15:00 and 22:59 insert "shift 2" in the cell.
If between 23:00 and 6:59 insert "shift 3" in the cell.

I am pretty sure that this formula will do that...

="Shift "&1+MOD(3+INT((24*A1-7)/8),3)

Rick

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200706/1