One way:

=COUNTIF(A1:A100,"<0:1:0")/COUNT(A1:A100)

In article ,
martha wrote:

i am trying to find the percent of times less than one minute in a range of
times. times are formatted 00:00:00