Hi Eric,

Am Fri, 18 Oct 2013 13:07:47 -0700 (PDT) schrieb Eric Ocasio:

A B C D
1 Name Start End Shift
2 John Doe 8:00 17:00 Value?

try in D2:
=IF(AND(B2=TIME(7,,),B2<TIME(15,,)),"First",IF(AN D(B2=TIME(15,,),B2<TIME(22,,)),"Second","Third"))
and copy down


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2