how do i figure percent

martha · Oct 11, 2005

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

JE McGimpsey · Oct 11, 2005

One way:

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