using a substitute value

[Tracy D.]

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

 

[Jim Thomlinson]

Try this formula. I assume you are starting in Cell A1

=COUNTIF(B2:B4,"A")*4 + COUNTIF(B2:B4, "B") * 6+COUNTIF(B2:B4, "C") *
8+COUNTIF(B2:B4, "D") * 5

HTH