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.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 10-13-2020 17:09
From: Jeremy Silvia
Subject: Overtime Hours Help
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
Original Message:
Sent: 10-13-2020 17:07
From: Mark Shnier (YQC)
Subject: Overtime Hours Help
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
Original Message:
Sent: 10-13-2020 16:48
From: Jeremy Silvia
Subject: Overtime Hours Help
Sure, here is the formula's I am using.
Overtime Hours
------------------------------
Jeremy Silvia
Original Message:
Sent: 10-13-2020 16:38
From: Mark Shnier (YQC)
Subject: Overtime Hours Help
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
Original Message:
Sent: 10-13-2020 16:36
From: Jeremy Silvia
Subject: 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)
------------------------------
Jeremy Silvia
------------------------------