D
David
I've set up a bi-weekly timesheet in XL2K for a two-week pay period.
D4
17 contains the calculated time worked each day
Overtime is paid for hours worked beyond 40 hrs in a week.
H19 calculates Regular hours worked with the following formula:
=MIN(40,SUM(D410))+MIN(40,SUM(D1117))
H20 calculates Overtime hours worked with the following formula:
=MAX(0,SUM(D410)-40)+MAX(0,SUM(D1117)-40)
Both formulas give the desired results. I'm just not sure that they are the
most efficient for the job.
Thoughts/Suggestions??
D4
17 contains the calculated time worked each dayOvertime is paid for hours worked beyond 40 hrs in a week.
H19 calculates Regular hours worked with the following formula:
=MIN(40,SUM(D4
10))+MIN(40,SUM(D1117))H20 calculates Overtime hours worked with the following formula:
=MAX(0,SUM(D4
10)-40)+MAX(0,SUM(D1117)-40)Both formulas give the desired results. I'm just not sure that they are the
most efficient for the job.
Thoughts/Suggestions??
