I am a retail operation with 4 shifts named A,B,C,D. I use the shifts to
shedule
A 8-12 - 4 hours
B 10-4 - 6 hours
C 12-8 - 8 hours
D 3-8 - 5 hours

I want excel to calculate a the total time scheduled based on the shift I
enter in the spreadsheet. Looks like this:

MON TUE WED...
Curly A C A
Larry B B B
Moe D C A
Total 15 22 14

Can't figure it out. Thanks