Try these in C2:F2, respectively:
=IF(B2>=360,A2,"")
=IF(AND(B2>=300,B2<360),A2,"")
=IF(AND(B2>=240,B2<300),A2,"")
=IF(B2<240,A2,"")
and then copy them all down the table.
you may need to adjust the operators, >, >=, <, <= depending on where you want to include/exclude the upper/lower bounds of each range.
Bookmarks