Rhone
04-27-2005, 12:21 PM
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.
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.