Ive been asked to create a formula to tell whether a single cells time is either AM or PM shift. Our AM shift is 05:45 to 15:45 while our PM shift is 15:46 to 01:15 the next day.

B3 is formatted to: m/d/yyyy h:mm and contains 1/2/2019 3:50:19 PM

Ive tried =IF(AND(B3=TIMEVALUE("05:45:00"),B3<=TIMEVALUE("1 5:45:00")),"AM","PM")

While the results show PM and this is correct, the cell above it contains 1/02/2019 3:13:24 and should result in AM €¦ but it results in PM as well.

What am I doing wrong?