How Can I Easily Track Late Arrivals in Excel Using Formulas for Our Biometric System?

Our organization consists of 28 members. We utilize a biometric attendance system for calculating attendance. In the attendance Excel sheet, one number occurs 25 to 26 times in a month with timings, and we have set 9:30 as our incoming timing. After 09:45, we mark it as late.

Could you please suggest some easy methods to determine how many times a specific number occurs after 9:46 using formulas?

You should use the formula below:
=COUNTIF(E2127:E2135, ">9.45") (=COUNTIF(Start cell reference:End Cell Reference, ">9.45"))

Please let me know if you need any further assistance.