Hi all. I have been consumed with a dilemma for weeks so I am hoping that someone can help me.
Right now, we have employees who either earn sick time or PTO (all-purpose Paid Time Off) depending on how many hours they work in the week. If they work less than 30 hours, they earn .03333 hours of sick time for each hour worked up to 40 hours earned per year. If they work 30 or more hours in the week, they earn .03333 hours of PTO time up to 56 hours earned per year. They can not earn more than 56 hours combined between the 2 types. So, in excel, this is easy - I just have a column that adds the 2 together and when the limit of 56 is reached, the accrual calculations for both stop.
We are trying to get this automated in our timekeeping system (Kronos) but they are telling me that they can't have an accumulator totaling across 2 buckets. I can have a max on each bucket but they don't interact with each other at all. So that means for example that an employee could be consistently working 30+ hours per week and reach the 56 hours of earned PTO so that would stop but then if their hours drop to under 30, they would start earning sick time too which we don't want. I am looking for ideas on how they can program this that might work. Any suggestions are appreciated!! Thank you!
Right now, we have employees who either earn sick time or PTO (all-purpose Paid Time Off) depending on how many hours they work in the week. If they work less than 30 hours, they earn .03333 hours of sick time for each hour worked up to 40 hours earned per year. If they work 30 or more hours in the week, they earn .03333 hours of PTO time up to 56 hours earned per year. They can not earn more than 56 hours combined between the 2 types. So, in excel, this is easy - I just have a column that adds the 2 together and when the limit of 56 is reached, the accrual calculations for both stop.
We are trying to get this automated in our timekeeping system (Kronos) but they are telling me that they can't have an accumulator totaling across 2 buckets. I can have a max on each bucket but they don't interact with each other at all. So that means for example that an employee could be consistently working 30+ hours per week and reach the 56 hours of earned PTO so that would stop but then if their hours drop to under 30, they would start earning sick time too which we don't want. I am looking for ideas on how they can program this that might work. Any suggestions are appreciated!! Thank you!
