IF Statement with Column of Time Values to Toggle Input Cell

[Gregg Gonsalves]

So, I have a series of 1000 consecutive arrival times from midnight to midnight in hh:mm form on one spreadsheet called Arrivals. On the preceding worksheet, I have an input cell for a formula for computations, which I'd like to make time-of-day dependent, that is, the input cell be 1 between midnight and 08:00 and 4 between 08:00 and midnight.
I've tried to do this with the formula =IF(Arrivals!A1:A1000>=HOUR(8),4,1) and it doesn't seem to work. Any suggestions?

[olasa]

Might be a start.
//Ola

=IF(A1<8/24,1,4)
00:00 - 07:59 --> 1
08:00 - 24:00 --> 4