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------------------------------
Original Message:
Sent: 01-21-2022 15:20
From: Matthew Jones
Subject: 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 and total them in field below for the pay type they selected for each day.
You can see in the screen shot each day has a set amount of fields for the time tracking. I need to associate the pay type to the Payroll hours and place the totals for each pay type in the lower total fields as a total for the week.
------------------------------
Matthew Jones
------------------------------