Please help with counting cells with time criteria

[Tonybaga]

Hi everyone
This is the first time I’m posting here and I tried to look for similar questions but couldn’t find an answer.
I have attached a picture of the column I am working on
Basically in this particular column, I want to count how many bookings are before 12pm and how many are after 12pm for the different dates.
So a function which would return the count of bookings before 12pm and after.
i would really appreciate it if you could help me with this. I’m stuck with this problem for a while.
thanks in advance

 

[Ezguy4u]

Let's get the ball rolling. Now if you could just say if this is what you want, that would be a good start. Once people see the input and output, they will be more helpful. I know there are more ways to solve this problem so let's see what happens when the A Students weigh in.

Book1
	A	B	C	D
1	Date Out
2	10/27/2020 09:00 AM	0.375	9	Bookings After 12 PM
3	10/27/2020 04:00 PM	0.667	5	Bookings Before 12 PM
4	10/27/2020 04:00 PM	0.667
5	10/27/2020 05:00 PM	0.708
6	10/27/2020 08:00 AM	0.333
7	10/28/2020 02:00 PM	0.583
8	10/28/2020 03:00 PM	0.625
9	10/28/2020 08:00 AM	0.333
10	10/28/2020 04:00 PM	0.667
11	10/28/2020 06:30 PM	0.771
12	10/28/2020 08:00 AM	0.333
13	10/29/2020 02:00 PM	0.583
14	10/29/2020 09:00 AM	0.375
15	10/29/2020 02:00 PM	0.583
Time

Cell Formulas
Range	Formula
C2	C2	=COUNTIF(B2:B15,">0.5")
C3	C3	=COUNTIF(B2:B15,"<0.5")
B2:B15	B2	=VALUE(RIGHT(TEXT(A2,".000"),4))

 

[Peter_SSs]

@Tonybaga
Welcome to the MrExcel board!

I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.
Thanks to @Ezguy4u for doing some of that typing.

I have taken a slightly different interpretation of the requirement based on

count how many bookings are before 12pm and how many are after 12pm for the different dates.

Assuming that you can use your Excel 365 and that it has the UNIQUE function you could try this. Each functon only needs to be entered in the top cell and the other results should automatically 'spill' to the other required rows.

20 10 28.xlsm
	A	B	C	D	E
1	Date Out		Date	Before Noon	After Noon
2	27/10/2020 09:00 AM		27/10/2020	2	3
3	27/10/2020 04:00 PM		28/10/2020	2	4
4	27/10/2020 04:00 PM		29/10/2020	1	2
5	27/10/2020 05:00 PM
6	27/10/2020 08:00 AM
7	28/10/2020 02:00 PM
8	28/10/2020 03:00 PM
9	28/10/2020 08:00 AM
10	28/10/2020 04:00 PM
11	28/10/2020 06:30 PM
12	28/10/2020 08:00 AM
13	29/10/2020 02:00 PM
14	29/10/2020 09:00 AM
15	29/10/2020 02:00 PM
16
Count Times

Cell Formulas
Range	Formula
C2:C4	C2	=UNIQUE(INT(A2:A15))
D2:D4	D2	=COUNTIFS(A2:A15,">="&C2#,A2:A15,"<"&C2#+0.5)
E2:E4	E2	=COUNTIFS(A2:A15,">"&C2#+0.5,A2:A15,"<"&C2#+1)
Dynamic array formulas.

 

[Tonybaga]

Thank you so much guys! that worked like a charm!!

 

[Ezguy4u]

My pleasure. Thanks for all the help and feed back

 

[Peter_SSs]

Thank you so much guys! that worked like a charm!!

Glad you got a successful outcome.

As a matter of interest, which was the correct interpretation of what you were after?