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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional