Finding the Average Duration Based on Criteria

An Excel file that teaches how to perform Finding the Average Duration Based on Criteria operation.

Excel Template for Finding the Average Duration Based On Criteria

Times are stored in hour format. The criterion average is calculated with the AVERAGE FUNCTION. Matches are established for text criteria. Incorrect or empty cells are excluded. The result is shown in a single cell.

Hope it is useful.