Stop Accrual Formula
Hello,
I need help creating a formula to stop the accrual process once a number of hours has been reached and then to begin the process again after hours have been used. My Columns are below
so once the balance is 240 then stop hours earned
and then once the balance is below 3.08hrs of 240 then resume accruing not sure if it's possible but will appreciate any and all help
Answers
-
I may have a solution for you though it may not be exactly what you are looking for.
2022 PTO Hours Earned (Converted to Column Formula): =IF(Balance@row + 3.08 < 240, 3.08, (240 - Balance@row))
2022 PTO Hours Used: Just a regular row - No Formula
Balance (Starting on the second row): =Balance1 + [2022 PTO Hours Earned]1 - [2022 PTO Hours Used]@row
I put the first balance amount as something that you would need to enter in manually. I also added a bit extra in the formula in case you wanted the person to earn up to the amount they could get without going over.
Hope this helps.
Heath Hilton
Hope this helps!
Heath Hilton
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!