Calculate Worked hours per week from a client dropdown list

Hello DiliPandey

I have attached a file with a macro code which inserts more than one item from dropdown list into one cell.

Sample A - I cannot get this to add up as there is more than one item (client) selected from the dropdown list.
Is this possible to do ?
Row AB5 is adding up for one client "BS" five night shifts (9hrs) giving 45 hrs

My overall problem is trying to add multiple clients together over seven days to get a weekly total of hours worked

Regards Garibaldi