In the Payroll module, the Query tool can be used to report on employee total hours worked by period end date.
I. Create a query:
1. Create a calculation query. 2. On the Criteria tab, select Calculations, Employee period end date [between] [Date 1] and [Date 2]. 3. Click OK. 4. On the Output tab, select Calculations: Hours Worked, Employee Full Name, and Employee ID. 5. Select the Results tab. 6. Click Save. 7. On the Results tab, click the Export to Excel button above the results grid and save the export file. 8. Save and close the query.