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