MATCH("",A2:AX2,-1)
it's brilliant
chapeau!
isabelle

Le 2015-10-28 13:46, Claus Busch a écrit :
Hi,

Am Wed, 28 Oct 2015 07:41:44 -0700 (PDT) schrieb :

The part I need help with is the bottom section which is the summary, rows 6-10.

a little bit shorter and without array:
=TEXT((VERGLEICH("x";2:2;0)-3)/2/24;"hh:mm")&" - "&TEXT((VERGLEICH("";A2:AX2;-1)-2)/2/24;"hh:mm")


Regards
Claus B.