Job card

I have recently put the companies jobcards on an excel sheet and sucesfully formulated all the time and breaks etc and then x it by the hourly rate.

My question is I have 5 employees on 3 diffrent hourlyrates – can I create a formula which when you entrer the employees name say in B1 that the hourly rate column will automatically match B6?

From instance Matt would = £30

Many thanks 

 

By: Jo

Leave a Reply

Your email address will not be published. Required fields are marked *