Working Hours

[kalles]

i need formula for accounting working hours on Sundays in a month.for example if employees worked 3 times in the month.formula must multiply 7.5*3

i hope i can explain.

[CheshireCat]

Hi,

In cell AL5 paste:

=SUMPRODUCT(--(WEEKDAY($D$4:$AG$4,1)=1),D5:AG5)

and autofill down.

[kalles]

Hi,

In cell AL5 paste:

=SUMPRODUCT(--(WEEKDAY($D$4:$AG$4,1)=1),D5:AG5)

and autofill down.

thank you so much