ExcelBanter - how do i figure percent

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i figure percent (https://www.excelbanter.com/excel-discussion-misc-queries/49773-how-do-i-figure-percent.html)

martha

how do i figure percent

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

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

All times are GMT +1. The time now is 08:31 AM.