I have an excel spreadsheet that I use for staffing. It totals the number of days, nights, weekends, etc that everyone is working. Now I have added another column that totals transport shifts. I need to make it so
when I type in someone's name for transport, the formula will count it and return 2 instead of 1 for their name. When people are working 12 hour shifts it returns 1. When they are listed in the transport section (a 24 hour shift) I need to to count it as 2 shifts without adding heir name another time. How do I do that?