If in between: auto-populate a column with a formula to various integers based on another column value

[glens]

HELP NEEDED
[TABLE="width: 640"]
<tbody>[TR]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"]A[/TD]
[TD="class: xl65, width: 64"]B[/TD]
[TD="class: xl65, width: 64"]C[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]1/2/2015[/TD]
[TD="class: xl67"]18:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]2[/TD]
[TD="class: xl66"]1/3/2015[/TD]
[TD="class: xl67"]8:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]3[/TD]
[TD="class: xl66"]1/3/2015[/TD]
[TD="class: xl67"]17:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]4[/TD]
[TD="class: xl66"]1/5/2015[/TD]
[TD="class: xl67"]3:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 6"]I would like column C to update to the corresponding shift[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 5"]If B is between 7:01 and 15:00, C is 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 5"]If B is between 15:01 and 11:00, C is 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 5"]If B is between 11:01 and 7:00, C is 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 9"]Then I would like to count the number of values in C that are equal to 1, 2, and 3 successively[/TD]
[/TR]
</tbody>[/TABLE]

 

[billszysz]

[TABLE="class: cms_table"]
<tbody>[TR]
[TD="colspan: 5"]If B is between 7:01 and 15:00, C is 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="class: cms_table"]
<tbody>[TR="class: px"cms_table_tr""]
[TD="colspan: 5"]If B is between 15:01 and 11:00, C is 2
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD]????????
[/TD]
[/TR]
[TR]
[TD]If B is between 11:01 and 7:00, C is 3
[/TD]
[TD="colspan: 5"][/TD]
[/TR]
</tbody>[/TABLE]
11:00 and not 23:00 ???

 

[glens]

[TABLE="class: cms_table"]
<tbody>[TR]
[TD="colspan: 5"]If B is between 7:01 and 15:00, C is 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="class: cms_table"]
<tbody>[TR]
[TD="colspan: 5"]If B is between 15:01 and 11:00, C is 2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD]????????[/TD]
[/TR]
[TR]
[TD]If B is between 11:01 and 7:00, C is 3[/TD]
[TD="colspan: 5"][/TD]
[/TR]
</tbody>[/TABLE]
11:00 and not 23:00 ???

My mistake, 23:00