Calculating Calif overtime on timesheet

[Guest]

I am having trouble with an overtime calculation on my timesheet. Basically,
if a person works more than 8 hours in a day they get overtime hours, if they
work over 40 in a week they get overtime. My problem is with Saturday hours.
I've got the formula working for the 40 hours in a week rule, but can't
figure out how to max the regular hours at 8 if the person works over 8 that
day, (but still under 40 for the week). I'd like to email my spreadsheet to
someone who may be able to help me). Can anyone spare a moment?

 

[Leith Ross]

Hello Kim,

I had to that a few years ago and then the law was change back to 40
per week and now it's back the way it was. Only in California. I would
be happy to help you out. My email is (e-mail address removed).

Sincerely,
Leith Ross