On Fri, 1 Feb 2008 22:42:28 -0500, "T. Valko" wrote:

That returns an incorrect result when hours 40.

The first reference to C2 needs to be reduced to straight-time hours if
hours 40:

=D2*(MIN(C2,40)+MAX(0,C2-40)*1.5)

--
Biff
Microsoft Excel MVP


Yup, I was looking at a wrong total along the way.

=C2*D2+D2*0.5*MAX(0,C2-40)

is shorter with no MIN
--ron