Converting text into numbers for sum on a roster

Hello, I am working on a roster that contains a number of different shifts that are for different hours. On the roster, we have different codes so people know what they are working. For example. A...