Washington overtime: How to calculate overtime Night/weekend hours
Summary:
Hi All,
We have a requirement to calculate overtime hours based on the hours category of the highest total in a week. Meaning if a person worked for 20 hours regular hours then he gets overtime calculated as regular overtime. If he works night hours time codes more in a week then Night overtime and the same for weekends.
I want to know how can system can read the past hours to calculate the overtime category in the fast formula.
Content (please ensure you mask any confidential information):
Can you please confirm if Oracle supports such a functionality?
Version (include the version you are using, if applicable):