I want to assign certin values to codes, such as:

1 has a value of 8 or

the color blue has the value of 8

Is this possible. I am writing a simple work schedule and would like to be able to track total time and over time of my staff. Example below. 1 have a value of 8 hours worked, D has a value of 0 hours worked.

Thanks for the help
LMP

DATE: JAN 1 2 3 4
NAME TH F SA SU

Joe (ft) 1 1 D D
Gene (ft) D 1 1 1