Hi,
I have attached a speadsheet of what I am trying to build.
After each working day I place in the hours of work they have done.
From Monday to Friday they get paid X amount and from Saturday to Sunday they get paid Y amount.
I have made the font red indicating areas I need help with.
As always any help will be much appreciated.
Thanks
If you change cell B21 to a decimal of hours worked, ie 2.5 hours for 2 hours 30 minutes, then this formula will do what you need
=IF(OR(WEEKDAY(A21=1,1),WEEKDAY(A21=7,1)),65*B21,50*B21) and copy down
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
it is still not picking up whether that day is a weekday or a weekend
B2=SUM(IF(($A$21:$A$308>=$A8+0)*($A$21:$A$308<=EOMONTH($A8+0,0)),IF(WEEKDAY($A$21:$A$308,2)<=5,50,65),0)*($B$21:$B$308+$C$21:$C$308/60))
Try this array formula and copy towards down
If you are unable to enter formula...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
see the attached file
If you are unable to enter formula, Unmerge cells and try again (Normally you can't enter array formula in merged cells)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Or try:
=SUM(IF(TEXT($A$21:$A$308,"mmmm yyyy")=$A8,IF(WEEKDAY($A$21:$A$308,2)<=5,50,65)*($B$21:$B$308+$C$21:$C$308/60)))
Ctrl+Shift+Enter.
works for me. see attached
Alansidman, If you look at cell F22 you will see the number 325. This is a weekday, so this should be 250.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks