my workbook file its upload here : https://www.excelforum.com/attachments/excel-formulas-and-functions/589922d1536740825-sumproduct-function-help-max-value-zeszyt__2.xlsm
Night Work Hours :
I use this function to sum 6 hours or 5 hours :
]
i want help how system count to max value 48 (<=48) ?
Weekend Pay:
i want some help there when user add D on Sat or San then system count by 1, max counts = 4
Day OFF:
i want some help there when user add R count -1, if user add P or A or B on hollidays dates then count +1, if user add P or A or B on Sat or Sun then count +1
can anyone help me please?
Night Work Hours :
I use this function to sum 6 hours or 5 hours :
Code:
=SUMPRODUCT((OFFSET($A8;0;31*($A$3-1)+1;1;31)<>"")*(IF(OFFSET($A8;0;31*($A$3-1)+1;1;31)=NO10;6;IF(OFFSET($A8;0;31*($A$3-1)+1;1;31)=NO11;5))))
i want help how system count to max value 48 (<=48) ?
Weekend Pay:
i want some help there when user add D on Sat or San then system count by 1, max counts = 4
Day OFF:
i want some help there when user add R count -1, if user add P or A or B on hollidays dates then count +1, if user add P or A or B on Sat or Sun then count +1
can anyone help me please?