Applies to versions: 1.5, 1.6

Exporting the Extended Employee/Job Report

Security Level Required: Manager, Employee Administrator or Payroll Administrator

Using the left pane Main Menu, click on: Administration » Payroll and Reports » Time Edit/Report

---

NOTE: If you wish to see raw times that include seconds select the EEJR Setup button at the top right hand corner and choose the tick box "Show raw times". The preset options do not serve a purpose at this time however may be used in a future release of TimeIPS





---



1. Run the Time Report with Extended Employee/Job Report selected in the Criteria pull-down and Spreadsheet (CSV) selected in the Select Format pull-down.
2. Click on the Export Report button.
   
   
   

---

NOTE: Your screen may look different, depending on your computer's operating system.

---



3. Select to Save the file to disk and save it in an easy-to-find location such as your desktop.
   
   
   


4. Double-click on the file to open the saved Extended Employee/Job report file.
   
   
   Opened Report
   
   

   ---

   NOTE: If a column is not wide enough, designated in numeric columns with "######", click and drag the column's right margin to extend it.

   ---

The extended job report includes the following employee and time event data:

• Name
• Emp Number
• Badge Number
• Time In
• Location In
• Error (if any, when clocking in)
• Time Out
• Location Out
• Error (if any, when clocking out)
• Time Worked
• Audit Note
• Pay Rate (viewable only by direct managers, manager of direct managers, or payroll administrators)
• Manager
• Dept
• Type
• Status
• Week number
• Job
• Billing Rate
• Job Code
• Job Type
• GL Number
• Category
• Customer
• Job/Clock Notes

Adding Subtotals for Time Worked

Using Excel's subtotal function, you can add subtotals for time worked for each employee.

1. Export the Extended Employee Job Report and open it in Excel (see steps above).
2. Click into cell A6 which is the first column header.



Selected Rows in the Report


3. Go to the Data menu - Subtotals option and select the following options:
   
   
   

---

NOTE: Excel should recognize the field header and automatically select all data records. If not, cancel from the Subtotal screen and start with step 2.

---

• At each change in: Name
• Use Function: Sum
• Add subtotal to: Time Worked

---

NOTE: De-select any other checkbox that was automatically selected.

TIP: Check the "Page break between groups" checkbox to print each employee's records on a separate page.

---

4. Click on the OK button. Excel will add subtotals of hours worked per employee.