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


  • In C35, formula copied across and down :


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!