timesheet formula

[David]

I've set up a bi-weekly timesheet in XL2K for a two-week pay period.
D417 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??

 

[Frank Kabel]

Hi
at least the second one can be simplified
H20:
=SUM(D417)-H19

 

[David]

Frank Kabel wrote

Hi
at least the second one can be simplified
H20:
=SUM(D417)-H19

Cool. Thanks.