Fast Formula for Daily threshold based on location.
Summary
Fast Formula for Daily threshold based on location.Content
Hi Experts,
We have requirement where overtime will be calculated only weekly(no daily overtime) after 40 hours for all US locations except Colorado.
But for Colorado there is daily threshold of 12 hours after which overtime will be calculated and weekly threshold of 40 hours.
We are able to fetch locations in the formula, but want to understand how to proceed with the calculations.
Thank You,
Madhu
0