I have a row for groups. Each group has a different amount of people in them. Each group ends their work shift at a certain time. I have many groups that end at different times. I need to keep track of how many people are working (prior to their end of shift) at a given time. SOW = Start of Watch / Shift and EOW =End of Watch / Shift.

Help?asking for help.xlsx