Date printed: 11-20-2017   Last updated: 09-01-2005

To view our complete support knowledge base and most current version of this article visit support.timeips.com.
316-264-1600
Information
Sales
Support

Applies to versions: 1.3, 1.4, 1.5, 1.6



Exporting a Time Report



You can export Time Reports into a Comma Separated Value (CSV) file that can be opened by most spreadsheet applications, such as Microsoft Excel or OpenOffice.

Security Level Required: Manager, 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 you wish to export with Spreadsheet (CSV) selected in the Select Format pull-down.
    OR
    Run the Time Report you wish to export with Web Page (HTML) selected in the Select Format pull-down.
  2. Click on the Export icon at the top of the page.


  3. Select to Save the report to disk.
  4. Open the report using any spreadsheet application such as Microsoft Excel or OpenOffice.


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

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.

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


    NOTE: Your screen may look different than the screen above, 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.

  5. Add subtotals for Time Worked for each employee (Optional)

    Selected Rows in the Report

    • Select each row with employee time, including the header row.
    • Click on the row 6 to highlight the entire row.
    • Scroll to the last employee record.
    • Hold down the CTRL key and click on the last row number, highlighting rows 6 to the end.

  6. Go to the Data menu - Subtotals option.

    The Subtotal Window

  7. Select the following options:

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

  8. Click on the OK button.



See Also:
Run a Time Report (1.6)
Insert/Delete In/Out Time (1.4)

©2004-2017 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.