Hi, I'm creating a roster, using the values "A" "B" and "C" for the different
shifts and I would like to be able to give each value the numerical value of
however many hours each shift is, without making the text in the cell change
to a number, but still be able to add up the number of hours at the end of
the line. In other words A = 8, B = 10, C = 12 and the total is 30. Hope
this makes sense. I am using MS Excel 2002. Many thanks! Mullet2262