Let's put total hours in A1. Assume that straight time is $12.00 per hour
and overtime is $18.00 per hour

=IF((A1<=40),A1*12,480+(A1-40)*18)


--
Gary''s Student - gsnu200738


"Earl A" wrote:

How do i write formul for hours over 40, anything over 40 is Overtime. I
can not find the formul to seperate reg time from overtime. Can some one help
me?