Time clock systems by TimeIPS
Call Now! 316-264-1600
Knowledge Base Search:  
Main Menu
· Home

· Table of Contents
· Article Index

· Downloads
· New Features
· News
· Web Links

TimeIPS Knowledge Base

Table of Contents: Article IndexPrintable Version

Applies to versions: 1.3, 1.4

Exporting the Extended Employee/Job Report

The Extended Employee/Job Report includes a detailed listing of every clocked event for every employee as well as all job entry logs, both flexible and validated. The following steps will walk you through exporting the report and adding the total time worked per employee.

Security Level Required: Employee Administrator or Payroll Administrator

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

  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.

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

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

  5. Double-click on the file to open the saved Extended Employee/Job report file.

    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
    • 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.

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

  4. 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.

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

TIP: You can hide columns you do not wish to view. Click on the column header to highlight the entire column then right-click on the column header and choose the "Hide" option.

TIP: You can move columns of information to a different area on the spreadsheet. Click on the column header to highlight the entire column then right-click on the column header and choose the "Cut" option. Click on the column header you want to insert the column in front of. Right-click and select the "Insert Cut Cells" option.

See Also:
Run a Time Report (1.3, 1.4, 1.5)

Was this article relevant to your question? Yes No
©2004-2019 TimeIPS, Inc. All Rights Reserved - TimeIPS and the TimeIPS logo are registered trademarks of TimeIPS, Inc.
"Intelligent Personnel System" "Run your Business. We'll watch the clock." are trademarks of TimeIPS, Inc.
TimeIPS is protected by one or more patents. Patent No. US 7,114.684 B2.