#### Roumen Roussev

##### New Member

- Joined
- Nov 21, 2018

- Messages
- 6

Now I use:

=COUNTIF($D5:$AH5;$A$13)*($N$13*24)+COUNTIF(D5:AH5;$A$14)*($N$14*24)+COUNTIF(D5:AH5;$A$15)*($N$15*24)

where

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

Image: https://ibb.co/WpQfQyY

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