Formula to calculate on time percentage based on custom criteria [HELP]

[99Mozart17]

Hello,

I am brand new to excel and need some assistance on how to enter a formula that will calculate the percentage of how many days a week an employee clocked in at 10:05am and anytime before that.

May
05/01/19	10:06
05/02/19	10:05
05/03/19	10:11

<tbody>
</tbody>

<tbody>
</tbody>

This is what i have so far

COUNTIF(B3:B5)," <10:06 "

Red indicates that i am unsure if that is right.

 

[Joe4]

Welcome to the Board!

Try this:

=COUNTIF(B3:B5,"<"&(606/1440))

Here is the logic.
Date/Time is stored as a number in Excel. Date is the number of days since 1/0/1900 (whole numbers). Time is the fraction of one day.
There are 1440 minutes in a day (24*60). 10:06 AM is equal to 606 minutes (60 * 10 + 6) divided by 1440.