better explanation of timesheet problem

[Rourke Waring]

The problem I have is that for each day I need a cell to compute reg. time and a cell to compute overtime:
a are regular time hours
b are overtime hours
x is each days total hours worked
y is the sum of hours worked during the rest of the week
z is the remainder of 40 hours (the overtime cut-off)- y
if x>8, a=8, b=any excess.
if x>=40 a=0, b=x
if x<8 and y<=40,a=x if x<=z (if x>z, a=x-b), b=pos(40-(x+y))

[Anne Troy]

You can try Chip Pearson's downloadable timesheets at:

http://www.cpearson.com/excel/topic.htm

under "T"

[Rourke Waring]

I've looked at Chip Pearson's sheets, but they do not solve the maximun weekly total requirement.

[sen_edp]

Hello Rourke

visit the url below, please

http://j-walk.com/ss/excel/files/timesht.htm

hope that helps