Need to do a carry over formula
Good morning, I am working on a time card system and have everything working for totals but i am needing to do a formula / rule for over time carry over. So like any time card anything over 40 hours ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp, you will copy your current complicated formula for Regular Earnings and call it [Regular Earnings before 40 hour Cap]. If you like, put it on the form to satisfy your self that it works. Of course it will, but i know form your past posts that it's a long formula.
The you will edit you current complicated formula for Regular Earnings and replace it with just this one line.
Min(40, [Regular Earnings before 40 hour Cap])
That says to take the smaller of 40 and the [Regular Earnings before 40 hour Cap]
Then you will make the formula for [Over Time Total] to be
[Regular Earnings before 40 hour Cap] - [Regular Earnings]
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
The you will edit you current complicated formula for Regular Earnings and replace it with just this one line.
Min(40, [Regular Earnings before 40 hour Cap])
That says to take the smaller of 40 and the [Regular Earnings before 40 hour Cap]
Then you will make the formula for [Over Time Total] to be
[Regular Earnings before 40 hour Cap] - [Regular Earnings]
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Ok so on the Regular earnings total here is the formal I have it now. Its kind of a lot as it is pulling the data from the Payroll Hours field for each week day to separate it, this formula is used in all the totals field but changed the pay type to the type for that totals field. How would i add the formula you are talking about to this?
If([Pay Type]="Regular Earnings", [Payroll Hours],0)
+
If([Pay Type2]="Regular Earnings", [Payroll Hours2],0)
+
If([Pay Type3]="Regular Earnings", [Payroll Hours3],0)
+
If([Pay Type4]="Regular Earnings", [Payroll Hours4],0)
+
If([Pay Type5]="Regular Earnings", [Payroll Hours5],0)
+
If([Pay Type6]="Regular Earnings", [Payroll Hours6],0)
------------------------------
Matthew Jones
------------------------------- MarkShnier__YouMathew, I think I explained the steps below. Post back if you have a more specific question.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ - I got it working, Again thanks for the help I'm still learning all this and you all make it a lot easier to get in the right direction.
------------------------------
Matthew Jones
------------------------------
