Hi All.
I am working on a project and I created two tables, one is payroll information and the other is a Timesheet. Now, I want whenever the timesheet form is submitted, it pulls the information on the “Net hours worked “field to auto-populate the field the “hours worked” field on the payroll table.
Also, is there a way I can calculate the timesheet table so that the start time and end time of work subtract the unpaid lunch hours to auto-populate the “Net hours worked “field on the table?
Please can anyone help me out with this?
Thank you.
