Time value result in on cell used in IF function in another not working

[kaia2001]

Time ranges from below to be compared in IF stated with column [@TIME]:

1ST=5:30 AM to 13:29 PM
2ND=14:00 TO 22:29 PM

The formulas in the Number column and the Week column will not work properly. How do I turn the info in the Time column into the time format I need to use in the Number Column to determine if the time falls between the two logical test?

Number	WEEK	DATE	TIME	MODIFYTS
FORMULA: =IF(AND([@TIME]>TIMEVALUE("05:30:00"),([@TIME])<=TIMEVALUE("13:29:00")),"1st","") CELL OUTPUT: blank	FORMULA: =WEEKNUM([@DATE]+553,2) CELL OUTPUT: "51"	FORMULA: =IFERROR(TEXT([@MODIFYTS]-TIME(8,0,0),"mm/dd/yyyy"),"") CELL OUTPUT: "06/08/2020"	FORMULA: =IFERROR([@MODIFYTS]-TIME(8,0,0),"") CELL OUTPUT: "7:06:00 PM"	CELL CONTENTS: 6/9/2020 3:06​

 

[kaia2001]

Screenshot of the spreadsheet is attached. The time column i converting to PST and the highlighted column should show if the time in the "TIME" column is 1st shift 2nd shift or 3rd.