Classifying the second largest value if a certain condition is not met

Originally Posted by Bo_Ry

Please try at
M2
=INDEX(B$1:K$1,MATCH(MAX(B2:K2),B2:K2,))
N2
=MAX(B2:K2)/SUM(B2:K2)

Drag M2:N2 down

Thank you for your input.

This seems to work for cells M11 to M17. However, cell M9 should have "Vigilance" in it, cell M10 should have "Moving" etc.. As mentionned in 2) on my original post:

"
2) When "Head-up" has the longest duration time but is accompanied by other events in a given interval (example: interval #2 -row 3-), I'd like to have the SECOND event with the largest duration time as my "Event" in column M with its according "Proportion" in cell N.
"

Any ideas on how to fix this?