build a temp for payroll with different pay for different job

[jessica]

I would like to build a temp for payroll my cells are
something like this
cell h =job type (a or b)will only be A or B
cell g =time hours
cell j = expenses to be (paid in cell L)
cell k = pay pay for A = 11.00 ( after 40 = 16.50)
pay for B = 9.50 (after 40 = 14.25)

cell l= bill +expenses
bill for A = 19.33 (over 40 = 28.99)
bill for B = 17.57 (over 40 = 26.35)
I need to include overtime if total hours goes over 40,
but has to be total for each day
example if paul work on job A for 10 mon,
and 10 on tue,
then he worked 10 on job B on wed,
and 10 on job B thur,
then on fri he worked 10 on job A,
and went into over time
then sat he worked 5 job B at overtime
he also had 25.00 expenses for lunch which would be billed
in cell k5:k11 would be pauls pay per day including
overtime after 40 hours worked and the total would be in
k12
paul would be paid 11.00 per hour for mon, tue and 9.50
per hour on wed, thur and 16.50 for Fri and 14.25 for sat
at the end of seven days would be total
in cell L would be the amount I billed each job per day
with overtime showing in correct row (fri) plus expenses.
I would have a spreadsheet that showed seven days a week
in one column
and column with job (A or B) expenses
rate of pay plus overtime if worked (depending on job)
and rate of bill for each day according to job

I hope you understand this, it seems confussing at times I
have worked on this for too long please please help I am
desperate
Jessica

 

[Lester]

Using the values you provided, I created a spreadsheet
that gives the results I think you're looking for.
However, I find an added challenge if Paul works for 4 hrs
on job A and 6 hrs on job B on the same day.
Another challenge is if Paul accumulates 40 hrs in the
middle of any given day during the week, instead of at the
end of the 4th day.
..