something like

assuming a1 = hourly rate=8/hr

t5=sum(b5:h5)*a1+if(sum(b5:h5)40,sum(b5:h5)-40,0)*a1*1.5+
sum(i5:o5)*a1+if(sum(i5:o5)40,sum(i5:o5)-40,0)*a1*1.5+
p5*a1

B5 to H5 is 1 week, I5 to O5 is 2nd week, P5 is a single day. S5 =
total
hours. T5 is Gross Pay = total hours x 8 an hr


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=276115