#1
|
|||
|
|||
another Excel question for you brilliant OOTiots!
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. |
|
|