Sat, 8 Dec 2007 18:43:15 -0000 from Roger Govier
<roger@technology4unospamdotcodotuk:
With Hours actually worked in A1, Standard price per hour ($7) in B1, and
A1*B1 in C1
then
=C1/((40+(A1-40)*1.5))
gives the value per hour to pay

So in A3 enter 40, in B3 enter the formula above and in C3 enter = A3*B3
in A4 enter =A1-A3, in B4 enter = B3*1.5, in C4 enter A4*B4

Please note that this is almost certainly illegal under US and state
labor laws.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/