yes, although most days have the same, these are;

mon - 11.5
tue - 11
wed - 11.5
thur - 11
fri - 11
sat - 11
sun - 11

HTH, thanks.

"Mike H" wrote:

Before attempting to answer this do Tuesday thru Sunday have values and if so
what?

Mike

"Noob McKnownowt" wrote:

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.