excel - Using Formula to determine Shift from Time data -

i have column of time data formatted this: hh:mm:ss

i want make if statement returns 1, 2 or 3 corresponding first, second or third shift if times fall between values.

=if(and(e50>8,0,0,e50<16,0,0),"first",(if(and(e50>=16,0,0,e50<24,0,0), "second", "third")))

that's looks now, doesn't work.

if put 3 shift start times in cells , reference them, simple this:

=if(and(d13>=$d$11, d13<$e$11),"first",if(and(d13>=$e$11,d13<$f$11),"second", "third"))

WIn