NEED Help For Cost Coding for Employee time

[FBP]

I am having difficulties trying to figure out how to add a catagory for cost code for my employees. I created an excel spread sheet for all my employees and how many hours they work each day. But each job they do per day has a different cost code (example: Monday John Smith 8hr - "Concrete" Tuesday John Smith 8hr- "Welding". How do i create a spread sheet where i can input the time work and what job he is doing. Keep in mind there is over 30+ codes that are used and overtime and over 30 employees.

Any help and advice will be great

[dogberry]

Hi

Probably not the best solution but have a look and see what you think Sheet 1 your worksheet for working out the pay JobRate sheet gives all the jobs and hourly rate.

Now the awkward bit column b on sheet one becomes a pulldown menu where the job is selected and that automatically inserts the pay rate into column C.

Chris