Hi,
I am after 2 formulas or 5 different formulas to fit my needs on
Formula (1 or 4):
4 Weekly range:
First 3 hours of the week: 0 to 3 -> 1
4 to 21 -> 2
22 to 36 -> 3
36 to 60 -> 4
Formula ():
If sum of hours per week reaches over 50 hours -> flat rate value of 200 for the full week (Monday to Friday)
Alternative: If days are part of the specific range of date -> flat rate value of 200.
Tips: Ideally, based on above formula, I will create a report (Pivot Table)
Bookmarks