If Else statement with time range for binning purposes

[masuzo]

Hi,

I need to perform binning on a time range using if else statement. Can anyone help me with the formula? I can't seem to get it to work...

Attached is the excel screenshot to help show what I am trying to accomplish.

Thanks.

 

[awoohaw]

Does this work? I put an early in, you can change that to "".

mr excel questions 5.xlsm
	A	B
2	18:36:58	Evening
3	11:08:14	Morning
4	02:58:43	Early
5	10:09:10	Morning
6	15:15:03	Afternoon
7	17:13:34	Evening
8	20:44:53	Evening
9	13:49:56	Afternoon
10	15:43:34	Afternoon
11	17:24:51	Evening
Sheet12

Cell Formulas
Range	Formula
B2:B11	B2	=IF(HOUR(A2)<7,"Early",IF(HOUR(A2)<12,"Morning",IF(HOUR(A2)<16,"Afternoon","Evening")))

 

[masuzo]

Does this work? I put an early in, you can change that to "".

mr excel questions 5.xlsm
	A	B
2	18:36:58	Evening
3	11:08:14	Morning
4	02:58:43	Early
5	10:09:10	Morning
6	15:15:03	Afternoon
7	17:13:34	Evening
8	20:44:53	Evening
9	13:49:56	Afternoon
10	15:43:34	Afternoon
11	17:24:51	Evening
Sheet12

Cell Formulas
Range	Formula
B2:B11	B2	=IF(HOUR(A2)<7,"Early",IF(HOUR(A2)<12,"Morning",IF(HOUR(A2)<16,"Afternoon","Evening")))

Thank you! It works perfectly !

 

[awoohaw]

Glad to help. Welcome to the forum.

If you find a post here helpful and provides an answer please mark it as the answer.