calculating time at different rates of pay

[Deborah]

I need a formula to calculate pay: for instance a driver
can drive a class A truck or class B both these have a
different rate of pay I need a formula that will calculate
example
Don drove 10 hours at class A pay which is 11.00 on Mon
he drove 12 hours at class A on Tue,
then he drove 15 on Wed at class B rate which is 9.50,
then he drove 10 at class B rate on Thur and
Fri he drove 10 at class A
he had 57 total
column g1 is for class A at 11.00
column h1 is for class B at 9.50
column j1 is the total each day(for instance 10 * 11.00)
when it reaches overtime no matter which column it will
calculate at the corect rate and put in that column
(I will have hours in one column or the other on that row,
but not both)Can this be done
Thanks Deborah

 

[Deborah]

-----Original Message-----
I need a formula to calculate pay: for instance a driver
can drive a class A truck or class B both these have a
different rate of pay I need a formula that will calculate
example
Don drove 10 hours at class A pay which is 11.00 on Mon
he drove 12 hours at class A on Tue,
then he drove 15 on Wed at class B rate which is 9.50,
then he drove 10 at class B rate on Thur and
Fri he drove 10 at class A
he had 57 total
column g1 is for class A at 11.00
column h1 is for class B at 9.50
column j1 is the total each day(for instance 10 * 11.00)
when it reaches overtime no matter which column it will
calculate at the corect rate and put in that column
(I will have hours in one column or the other on that row,
but not both)Can this be done
Thanks Deborah
.

 

[DNF Karran]

=IF(B1=0,"",IF(B1<8,IF(A1="A",B1*11,IF(A1="B",B1*9.5,"ERR!")),((B1-8)*20)+(IF(A1="A",B1*11,IF(A1="B",B1*9.5,"ERR!")))))

This assumes the Overtime is £20/hr.

You need to put the number of hours worked in B1 and the class (eithe
A or B) in A1 eg for 10 hours on class A the result is £150.

A simple spreadsheet capable of recording hours worked is available fo
download at http://uk.geocities.com/duncankarran/excel-index.html

Dunca

 

[rbanks]

Deborah,

too complicated for one formula. Try this (see attached file)

Attachment filename: pay_sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52601