Just because I'm a nit picker.....

If they work <40 hrs the formula crashes.

Biff

"MartinW" wrote in message
...
Hi help in CA,

Try this formula in B1 =600/(((A1-40)*1.5)+40) and format
it to 2 decimal places.

In A1 put your total hours say 65 which gives you an effective
payrate for that week of $7.74 per hour.

HTH
Martin