Originally Posted by Claus Busch

Hi Roumen,

Am Mon, 3 Dec 2018 10:03:58 +0000 schrieb Roumen Roussev:

D5:AH5 is range with shift symbols
A13:A15 is range for symbols fom legend
N13:N15 is range of corresponding symbols value with "hh:mm" formatting

This is the WeTransfer link to an Excel file. https://we.tl/t-eyGTJAH9KB

you must unmerge A17:A18. Then you can use:
=SUMPRODUCT(($A$13:$A$29=D5:AH5)*$N$13:$N$29)*24

Have a look for AJ5:AJ7:
https://1drv.ms/x/s!AqMiGBK2qniTgeAJF9321HfNoZKV1g


Regards
Claus B.
--
Windows10
Office 2016