Working Hours

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

CheshireCat

New member
Joined
Dec 30, 2011
Messages
121
Reaction score
0
Points
0
Location
Victoria, Canada
Excel Version(s)
Microsoft Excel 2013
Hi,

In cell AL5 paste:

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

and autofill down.
 
Top