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
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
------------------------------
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__You
Qrew Legend
Qrew LegendMathew, I think I explained the steps below. Post back if you have a more specific question.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------