Forum Discussion

Qrew Trainee

3 years ago

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...

Formulas and functions

MarkShnier__You

Qrew Legend

np,
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
------------------------------

MatthewJones

Qrew Trainee

3 years ago

Mark,

Thank you for the help this worked Perfect and is getting me in the right direction.

------------------------------
Matthew Jones
------------------------------