Modifying a formula

  • Hello,

    This spreadsheet tracks teams that have worked (3-2) means tm 3 did 2 hours. I did not take into account that multiple teams could work the same day. How can I modify the formula to recognize more then 1 team in a cell. I would simply like to separate with a comma so 1 cell could have ( 3-2,1-1) in the same cell and the formula still work. there could be 4 entries in the cell

    is this a bridge too far?


    Cell P16 is an example of the multiple entries

    Thanks

  • In C35, formula copied across and down :


    =SUMPRODUCT(-TEXT(LEFT(TEXT(MID(C$3:C$33&"@",FIND($A35&"-",C$3:C$33&$A35&"-")+1,COLUMN($A:$I)),),COLUMN($A:$I)-1),"[<>];;;\0"))