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
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Matthew, it seems to me that you would just use the exact same method as you used for regular time.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
MikeTamoush's avatar
MikeTamoush
Qrew Elite
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 Elite
      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
      ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Think that you have a conceptual problem.

    The fact is that overtime is overtime. At least where I come from if the employee works more than 40 hours a week then they get paid overtime. So if they worked 30 hours regular time and 20 hours in training and 10 hours non billable, for a total of 60 hours, they worked 20 hours that week then they worked 20 hours of Overtime.  The formulas will get enormously complicated to break that out as to which type of time caused the O/T.  Because of the way you enter your data I think it is possible to calculate the overtime but you would probably need some outside assistance with the formulas as they will get very complicated.

    Or just have one bucket for overtime.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • MatthewJones's avatar
      MatthewJones
      Qrew Trainee
      4 years ago
      Ya that is my issue we have to have the other pay code types because of the industry we are in we have to be able to track and break it down.  If it was one over time code the fix you gave me this morning works great but now i have to bucket it out and that' is where I'm banging my head on the wall.

      ------------------------------
      Matthew Jones
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        You can contact me by my direct email in my signature line if you have a small budget for outside consulting.
        I think that the solution will be to have a new "column" on your grid at the right for the running total of the Overtime.  You do have an unusual situation where the required fields are all on one record and there is not the complication of child records and which came "first".

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------