Hello ladies and gentlemen,

when i first thought of this idea i didnt think it would be to diffcult to
produce, this initial thought has proven wrong :)

my problem is simple, i have created a table representing the days of the
week, in the following columns i have the amount of people and total hours,
such as;

day | people | Hours |
______________________________
monday | | |


what i want to do is input the amount of people and then have a result
calculated in the hours coloum, to do this i need to assign the word monday
with a numeric value i.e. 4.

so if i input 2 in the people column the result calculated in the hours
column would be 8.

houw can i do this, any assistance would be greatly appriciated.

the noob.