| 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 | |||
Linear Mode
