Custom formula for time keeping
I am looking to create a totals field for pay types in a time card system. I have created the time keeping report for the week for employees to put in their daily times. I am needing to take the times...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
The first formula would look like
IF([Pay Type Monday]="Regular Earnings", [Payroll Hours Monday],0)
+
IF([Pay Type Tuesday]="Regular Earnings", [Payroll Hours Tuesday],0)
etc ....
+
IF([Pay Type Sunday]="Regular Earnings", [Payroll Hours Sunday],0)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
The first formula would look like
IF([Pay Type Monday]="Regular Earnings", [Payroll Hours Monday],0)
+
IF([Pay Type Tuesday]="Regular Earnings", [Payroll Hours Tuesday],0)
etc ....
+
IF([Pay Type Sunday]="Regular Earnings", [Payroll Hours Sunday],0)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark,
Thank you for the help this worked Perfect and is getting me in the right direction.
------------------------------
Matthew Jones
------------------------------
Thank you for the help this worked Perfect and is getting me in the right direction.
------------------------------
Matthew Jones
------------------------------
