Employee Check-in TIme

[Luis Nic]

Hello im trying to get how many times my employes come in late, ive tried countif but the format of the data dosent match.
the emplyes have a tolerance of 16 minutes past there chekin time.

i uploded the sample data, hope you can help... i have 300 employes

 

[vletm]

One possible, if really would like to use formulas.

 

[Chihiro]

One main issue is that you have Datetime masquerading as Time in range E3:R4.

Also, it's not good idea to mix data types.

Having said that try using following formula.
=SUMPRODUCT(($E$2:$R$2="Chek in")*ISNUMBER($E3:$R3)*(IFERROR(MOD($E3:$R3,1),0)>$B3))

Confirmed as Array (CTRL + SHIFT + ENTER)

Or below variation, as regular formula.
=SUMPRODUCT(($E$2:$R$2="Chek in")*ISNUMBER($E3:$R3)*($E3:$R3>E$1:R$1+$B3))

 

[Luis Nic]

wow than you vletm and chiiro, both work grate. thas how the data is extracted, cant do much for it.