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