In a monthly payroll scenario, where the payroll period is from the 25th of one month to the 24th of the next month, a staff member works a varied number of hours each day and worked for a number of days within the payroll period.
There are also a number of staff members working under the same circumstances - that is, working a number of hours each day for a number of days during a payroll period
How do I calculate in Knack the total number of hours worked "per payroll period" "per staff member"?
Note 1 - the staff member submits a timesheet each day recording the total number of hours they've worked for that day.
Note 2 - I have created objects for Staff Members, Pay Periods, Timesheet, Timecard etc.
This can be done in Excel as shown here https://exceljet.net/formula/get-work-hours-between-dates - so looking to be able to do same in Knack.
Also, I've tried the netWorkDays function in Knack but it keeps returning the wrong output:
Thanks in advance!