Forum Discussion

MatthewJones's avatar
MatthewJones
Qrew Trainee
4 years ago

Over time Rule to Separate hours based on Pay type

Ok I have 1 more issue with creating an overtime rule in the timecard system, this morning I was able to get a 40-hour rule working to move hours from regular Earnings after 40 hours to Regular over ...
App builders
Formulas and functions
MikeTamoush's avatar
MikeTamoush
Qrew Commander
4 years ago

Mark,

I think the issue is that All buckets can trigger the 40 hour over time kick.

So if you have 20 hours Regular, 10 hours training, and 10 hours non billable, that is 40 total hours and now any bucket is triggered to overtime.

But you can't just add things up, the non overtime hours go to the earliest dates/times. Every hour logged after the date/time of the entry when 40 hours was busted in the combined buckets, kicks off the over time.

At least that is how I understand the posting.

------------------------------
Mike Tamoush
------------------------------

MatthewJones's avatar
MatthewJones
Qrew Trainee
4 years ago
Mike that is correct all buckets / Pay types trigger the overtime rule. So they would all need to be grouped so when the 40 hour mark is hit it would know where to send the hours for each pay type after the 40 hour mark. 

So if you have 20 hours Regular, 10 hours training, and 10 hours non billable, that is 40 total hours and say I have another 5 hours of Regular time and 5 hours of training time for a total of 50 hours 5 hours of Regular time would go to regular over time bucket and 5 hours of training time would go to training over time bucket. 

------------------------------
Matthew Jones
------------------------------
  • MikeTamoush's avatar
    MikeTamoush
    Qrew Commander
    4 years ago
    I agree with Mark regarding the conceptual issue.

    If you do decide to go down the rabbit hole, I highly recommend contacting Mark. He has helped me immensely as a consultant and has a real knack for using all kinds of tricks to get the most out of QuickBase.

    ------------------------------
    Mike Tamoush
    ------------------------------