I have a column of durations formatted as "hh:mm:ss".
I use AVERAGEIFS to return the average of the durations that also match a particular date.
For example, I have the following formula in
=AVERAGEIFS( $B$2:$B$12, $A$2:$A$12, D3)
The formula works but I want the result displayed in minutes only.
I tried using the HOUR function but it requires 3 arguments.
Can anyone help to convert the formula results in
(highlighted in yellow in the image) into minutes without removing the AVERAGEIFS formula?