I have a spreadsheet that I would like to calculate pay for my employees.
The get a special rate depending on how many times they do function. Also I
have different level for employees skill levels. Example

Level I
Jobs Pay
1 $15
2 $35
3 $55
4 $70
5 $85

Level IV
Jobs Pay
1 $21.25
2 $55
3 $75
4 $100
5 $120

I keep track of the numbers per shift

Exampe

Employee Start End Jobs Pay
John 0900 1500 5
Joe 0900 1200 2


John is a level 4
Joe is leve 2

I need the formula to calculate the pay column

Any ideas?

Thanks

Tom