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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]May[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05/01/19
[/TD]
[TD]10:06
[/TD]
[/TR]
[TR]
[TD]05/02/19[/TD]
[TD]10:05[/TD]
[/TR]
[TR]
[TD]05/03/19[/TD]
[TD]10:11[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 268"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.