Forum Discussion

JeremySilvia's avatar
JeremySilvia
Qrew Member
5 years ago

Overtime Hours Help

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
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    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
    ------------------------------
    • JeremySilvia's avatar
      JeremySilvia
      Qrew Member
      5 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        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
        ------------------------------