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)
...
Forum Discussion
Sure, here is the formula's I am using.
Overtime Hours
------------------------------
Jeremy Silvia
------------------------------
Overtime Hours
------------------------------
Jeremy Silvia
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendOh 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------- MarkShnier__YouPerfect, 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
------------------------------- God Bless you Mark, that was it! I appreciate your help
------------------------------
Jeremy Silvia
------------------------------