I am trying to average the below in DD:HH:MM format. The cells format is set as "custom > DD:HH:MM".
I want to only average the time for the the rows that have "APPLE" and "RIPE" in them using the Cell reference instead of the actual words "APPLE" and "RIPE".
I've tried AVERAGEIFS and various other solutions from many forums and can't get anything to work. Hoping there is a genius here that has a solution. Thanks in advance.
I want to only average the time for the the rows that have "APPLE" and "RIPE" in them using the Cell reference instead of the actual words "APPLE" and "RIPE".
I've tried AVERAGEIFS and various other solutions from many forums and can't get anything to work. Hoping there is a genius here that has a solution. Thanks in advance.
A | B | C | |
1 | APPLE | RIPE | 00:01:23 |
2 | APPLE | ROTTEN | 00:15:33 |
3 | ORANGE | RIPE | 00:14:47 |
4 | PEAR | RIPE | 01:00:48 |
5 | APPLE | RIPE | 06:09:05 |
6 | APPLE | RIPE | 00:14:47 |
7 | APPLE | RIPE | 00:15:33 |