Need help in counting time

[jyots_piyu]

HI FRIENDS I HAVE BELOW DATA WITH ME, NOW I WANT TO COUNT HOW MANY DAYS EMPLOYEE PUNCHED IN BEFORE 9 AND HOW MANY TIME THEY PUNCHED BETWEEN 09:15 TO 09:30 AM
[TABLE="width: 1185"]
<colgroup><col><col><col span="2"><col><col><col span="2"><col><col><col span="2"><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 249"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 4"]MS.Y[/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD]C1[/TD]
[TD]D1[/TD]
[TD]E1[/TD]
[/TR]
[TR]
[TD]Days[/TD]
[TD]Detail[/TD]
[TD]InTime[/TD]
[TD]OutTime[/TD]
[/TR]
[TR]
[TD]1 F[/TD]
[TD]P[/TD]
[TD="align: right"]09:00[/TD]
[TD="align: right"]17:56[/TD]
[/TR]
[TR]
[TD]2 St[/TD]
[TD]P[/TD]
[TD="align: right"]10:16[/TD]
[TD="align: right"]17:22[/TD]
[/TR]
[TR]
[TD]3 S[/TD]
[TD]WO[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4 M[/TD]
[TD]P[/TD]
[TD="align: right"]09:41[/TD]
[TD="align: right"]18:05[/TD]
[/TR]
[TR]
[TD]5 T[/TD]
[TD]P[/TD]
[TD="align: right"]09:10[/TD]
[TD="align: right"]18:00[/TD]
[/TR]
[TR]
[TD]6 W[/TD]
[TD]P[/TD]
[TD="align: right"]09:23[/TD]
[TD="align: right"]18:01[/TD]
[/TR]
[TR]
[TD]7 Th[/TD]
[TD]P[/TD]
[TD="align: right"]09:14[/TD]
[TD="align: right"]16:15[/TD]
[/TR]
[TR]
[TD]8 F[/TD]
[TD]P[/TD]
[TD="align: right"]09:31[/TD]
[TD="align: right"]18:33[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

Hi, welcome to the forum.

Here is one option you can try:

Excel 2013
	B	C	D	E	F	G	H
1	Days	Detail	InTime	OutTime
2	1 F	P	09:00	17:56		Before 9am	0
3	2 St	P	10:16	17:22		Between 09:15 and 09:30	4
4	3 S	WO
5	4 M	P	09:41	18:05
6	5 T	P	09:10	18:00
7	6 W	P	09:23	18:01
8	7 Th	P	09:14	16:15
9	8 F	P	09:31	18:33
Sheet1

Cell Formulas
Range	Formula
H2	=COUNTIFS(D2:D9,"<09:00")
H3	=COUNTIFS(D2:D9,">=09:00",D2:D9,"<=09:30")

 

[jyots_piyu]

dear sir,
Thanks a ton, it works.

actually i had tried using count and countif, but failed,

 

[FormR]

Great, good to hear hope you were able to spot where you went wrong with your attempts.