Skip to main content
Question

Overtime Hours Help

  • October 13, 2020
  • 0 replies
  • 60 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement