If a time is between 2:00PM and 11:00PM enter 1 otherwise blank

[Guest]

I am predicting an occurrance to happen at a specific time (cell C9). I want
to look at that time and if it is between 7:00AM & 3:00PM enter a 1 (in cell
10) (represents 1st shift), if between 3:00PM & 11:00PM enter a 2 (represents
2nd shift) if betweem 11:00pm & 7:00AM enter a 1 (represents 1st shift).

 

[Bob Phillips]

=IF(AND(C9>=--"07:00:00",C9<--"15:00:00"),1,IF(AND(C9>=--"15:00:00",C9<--"23
:00:00"),2,3))

--

HTH

RP
(remove nothere from the email address if mailing direct)