Calculating timesheet using IF Function?

[conks]

Hi,

I need help with a timesheet that I’m producing.

The timesheet is to automate the calculation process by determining the rate of the worker by the following:

• Name of worker.
• Day of week to be worked
• Hours of work/shift.

I’m thinking about the IF function to determine this but am not sure if this is the best approach.

I’ve attached a spreadsheet which should explain all.

Can you help me with the best option, and code etc.

Thanks.

[tigertiger]

You should add the date of time

And using VLOOKUP and IF to deal with the problem
.