Multiply the percentage of time in each phase by the total time of the cell cycle 720 minutes and this gives you an estimate of the time. Summary To calculate percent of a total ie. The COUNTIF result is divided by the COUNTA result.
COUNTIFB2B16D2COUNTAB2B16 into your specified cell and press Enter key and then you will get a decimal number as following.
In the example shown. To calculate the number of viable cellsmL. In the formula line or directly into the cell enter A1 B1. Calculate the percentage of the cell spent in each stage.