Set of formula for specific time duration, using COUNTIFS
If the formula for Less than 5 minutes is =COUNTIFS($J$22:$J$9999,"<"&TIME(0,5,0),$K$22:$K$9999,B4)
and the formula for Greater than 10 minutes is =COUNTIFS($J$22:$J$9999,">"&TIME(0,10,0),$K$22:$K$9999,B4)
what should be the formula for Greater than 5minutes, less than 10 minutes using =COUNTIFS
This formula will check if the values in column J are greater than 5 minutes and less than 10 minutes and if the corresponding values in column K match the criteria in cell B4. It will then count the number of rows that meet these conditions.
This formula will check if the values in column J are greater than 5 minutes and less than 10 minutes and if the corresponding values in column K match the criteria in cell B4. It will then count the number of rows that meet these conditions.
This formula will check if the values in column J are greater than 5 minutes and less than 10 minutes and if the corresponding values in column K match the criteria in cell B4. It will then count the number of rows that meet these conditions.