[Rhone]

I have a column A, formatted for time, like:

13:45
9:38

etc.

Next to it I would like each cell in column B to take its corresponding cell from A, and return a number 1 through 4, depending on which 6 hour period the time from column A falls in.

so,

00:00 to 5:59 --> 1
6:00 to 11:59 --> 2
12:00 to 17:59 --> 3
18:00 to 23:59 --> 4

Any idea how to code column B?

thanks guys,

Rhone.