Determining overtime hours on the Time Cards/Time Sheets tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2019 10:10 AM
Hello,
We are looking for a way to have overtime hours calculated when a user submits a time card with the "Overtime" category selected. Currently, it totals the hours for the worked days using the OOB BR "Calculate total".
What our users are looking for is a way for them to enter the hours worked (7.5) and have it calculate the time and a half for that day. What we would also need is a way to have the calculated Overtime hours added into the Time Sheet weekly total. Can this be done through a few new fields and business rules, or is there a better way to go about it? If so, what kind of script would we be looking at?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2019 10:16 AM
The best way would be an After Business Rule that would calculate any records on that table that are marked overtime. I would have it subtract the number of hours from 7.5, and then apply that to an additional field which would be labeled overtime. I believe that would be the easiest and simplest route to do it.
You should only have to create one business rule and one field, unless one already exists.
If this answer was helpful, please mark it as such.
