Working Hours

K

kalles

New member
Joined
Apr 23, 2012
Messages
3
Reaction score
0
Points
0
[h=2]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[/h]
i hope i can explain.​
 

Attachments

  • question.xls
    29 KB · Views: 22
Hi,

In cell AL5 paste:

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

and autofill down.
 
You must log in or register to reply here.
Back
Top