Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting a number to look like a Percent without a percent sign | Excel Discussion (Misc queries) | |||
Splitting a Target Figure | Excel Worksheet Functions | |||
Custom percent format needed | Excel Worksheet Functions | |||
percent formulas | Excel Worksheet Functions | |||
how to type a minues figure | New Users to Excel |