Working hours in one week depending week no

**Zsrinker2** · 06-21-2010, 06:54 AM

Hello,

I’m Benny and new on this forum.

I have a question about calculating working hours in combination with the week number of the year.

I've attached a excel File where you can see a year calendar, week numbers, day's, In and Out times + totals.
Per day it is possible to putting in 4 different jobs.

Normally, a fitter works 40 hours during a week. (0% column)
- If he works more than 40 hours a week, the overtime hours per day must be automatically jump in the 50% column
(Like you can see in the yellow cells J65 an J66)

- If they work on Sunday, the hours must be automatically jump in the 100% column (Like you can see in the red cells K69)

Can anyone help me out with the formula ore VBA code?

Best regards

**Zsrinker2** · 06-22-2010, 03:13 AM

anyone who can help me?

best regards

**trucker10** · 06-23-2010, 01:28 PM

Kijk eens naar een formule somproduct , voor de zondag =WEEKDAG(cel;1) voor zondag
hier staat een voorbeeldje van een somproduct enz.

Look at a SUMPRODUCT formula for the Sunday = WEEKDAY (cell, 1) for Sunday
Here is an example of a SUMPRODUCT etc.