adding cells with non-traditional values

[gocolonel77]

I have been trying to figure our a way to assign a value to a non-numerical set and then have the cells automatically autosumed

For instance I want 3-C to mean 7.5 or 10-2 to mean 4.

So lets say cell C34 is the added hours I manually add up on a calculator to find the projected hours I am going to use for that day in that column. Call the column Sunday.

I apologize I have been trying to attach an example but the system is unavailable.

Thanks in advance for any help anybody can offer.

Jason