Why did you show 17:00 as the switch over between Day and Late rather than
16:00?

Rick


"Bob Phillips" wrote in message
...
=IF(AND(A1=--"00:00",A1<--"08:00"),"Early",IF(AND(A1=--"08:00",A1<--"17:00"),"Day","Late"))

--
__________________________________
HTH

Bob

"Shirley4589" wrote in message
...
Can you calculate whether a time is between two other times to show
early,
day or late shifts for example?