Average of minimum duplicate value.

[Philippe de Vlaminck]

Hello guys,
question regarding averages:

I am looking for a way to average the time in the columns with hours and that for each column. It may only select the lowest value of the lines with duplicates (since this time stamp is relevant).
Any ideas? Been trying with averageifs, min, ... but haven't found a decent solution yet.

Part of the file:


Thanks in advance,
Kind regards
Phil

 

[Philippe de Vlaminck]

Works like a charm, I added another IF for the 'IN' and 'EX' allowing me to more easily make the addition for the overall average.
Final formula: =IF(B14="IN",IF(H14=MIN(IF(A$14:A$202=A14,IF(B$14:B$202=B14,IF(C$14:C$202=C14,H$14:H$202)))),H14,""),"")
Moved some columns around aswell.

Grts,
Phil