G
Guest
I'm looking for a formula to find the average of numbers in a column that are
greater than 0. For example, in column A, there are reaction times. In column
B, there are final times. Say cell A1 is 3:25 AM and cell B1 is 3:45 AM. In
cell C1, I have the formula =B1-A1 to give me the amount of time in between
B1 and A1. The formula is copied down the column giving the cells the value
of 0. I need to find the average final times but without the 0 values. Any
help would be greatly appreciated. Thank you
greater than 0. For example, in column A, there are reaction times. In column
B, there are final times. Say cell A1 is 3:25 AM and cell B1 is 3:45 AM. In
cell C1, I have the formula =B1-A1 to give me the amount of time in between
B1 and A1. The formula is copied down the column giving the cells the value
of 0. I need to find the average final times but without the 0 values. Any
help would be greatly appreciated. Thank you