Discussions

 View Only
  • 1.  Overtime Hours Help

    Posted 10-13-2020 16:37
    Good Afternoon All,

    I was tasked with creating an application that can calculate overtime hours. I have set it up correctly and it works for anyone that works over 40 hours.  (See Below)

    The problem I am running into is when an employee works less than 40 hours, the formula is showing that the employee owes us money.


    Is there a way to have the overtime hours = 0 if it is a negative value? I believe that would fix everything. I am open to suggestions or questions.

    Thank You!


    ------------------------------
    Jeremy Silvia
    ------------------------------


  • 2.  RE: Overtime Hours Help

    Posted 10-13-2020 16:38
    Can you post your current formula.
    Mark

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Overtime Hours Help

    Posted 10-13-2020 16:49
    Sure, here is the formula's I am using.

    Overtime Hours

    Overtime Rate

    Hourly Rate
    Amount Due

    I hope this is what you were looking for, if not I will respond with more info.




    ------------------------------
    Jeremy Silvia
    ------------------------------



  • 4.  RE: Overtime Hours Help

    Posted 10-13-2020 17:07
    Oh sorry, I should have asked you to copy and paste the actual code in as opposed to a picture of the code.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Overtime Hours Help

    Posted 10-13-2020 17:10

    Not a problem, here it is

    Overtime Hours
    [Hours Worked]-40

    Overtime Rate
    [Hourly Rate]*1.5

    Hourly Rate
    [Salary Day Rate]/8

    Amount Due
    [Overtime Hours]*[Overtime Rate]



    ------------------------------
    Jeremy Silvia
    ------------------------------



  • 6.  RE: Overtime Hours Help

    Posted 10-13-2020 17:12
    Perfect, try this for the Overtime hours

    Max(0, [Hours Worked]-40)

    That says to take the higher of zero and your calculation, so it can't go negative.


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Overtime Hours Help

    Posted 10-13-2020 17:16
    God Bless you Mark, that was it! I appreciate your help

    ------------------------------
    Jeremy Silvia
    ------------------------------