Work Hours Report

Work Hours Report

Work Hour Calculation Report

1.0 Introduction

The work hour calculation report allows you to generate a report that displays who has been at work that day (who entered the premises with a valid credential) and it accurately calculates the work hours and total minutes - based on access granted messages generated from two or more different readers. The readers can be controlling separate doors or they can be entry and exit readers on the same door. This setup uses an entry and an exit reader controlling a single access point (main entrance door).

 

2.0 Name the Readers

The following steps assume you already have an NXT-MSC controller online and you have also added an NXT exit reader to the system.
  1. In Doors.NET go to Setup >> Hardware Setup >> All.
  2. Select each of the readers and give each reader a meaningful description.

    Rename Readers
  3. Ensure you have saved the reader settings.

 

3.0 Generate Access Granted Events

The next step is to generate an access granted event at the readers:
  1. First, generate an access granted event at the entry reader.

    Access Granted Event - Entry

  2. Some time later in the day, with the same credential, generate an access granted event at the opposite exit reader.

 

4.0 Define the Report Parameters

  1. Click on Reports >> Transactions.
  2. Select the time and date range for the report. For example: run the report just for today.

    Set report time and date

  3. Select Yes to limit the hardware selection.
  4. Select Yes to limit the message type selection.
  5. De-select the 'Use Default Sorting, Card Detail, .....' option.

    Report Parameters

  6. Click NEXT.

 

5.0 Select the Readers to Participate in the Report

The next screen to display will be all the readers on the system:
  1. Place a check mark against the 'reader' (from the select hardware type list).
  2. Then place a check mark against each of the entry and the exit readers (displayed on the right).
    Select Entry and Exit

  3. Click NEXT.
  4. Select the Access Granted message type only (as highlighted).

    Select Access Granted

  5. Click NEXT again.

 

6.0 Run the Report

  1. On the next screen, place a check mark against 'Work Hour Calculations'.

    Select Work Hour

  2. Select Timestamp Controller - to use the exact time that the credential was presented at the reader.
  3. Click NEXT.
  4. Finally, click the Run Report icon.

    Run Report

  5. The report will be generated and a calculation of the time in the building will be displayed for each of the cardholders that got access granted that day.

    In Building Report

  6. The work hours are listed in decimal format to two places so an operator can note fractions of an hour.

 

7.0 Save the Report Parameters

On the same screen that you ran the report you can also save the report. This will save the report parameters that you selected in the previous section.

  1. Enter a name for the report.
  2. Click on the Save icon.

    Rename report

  3. The report parameters will then be available to select when you next open the transaction report wizard.

    In building select

 

Note: As with the standard transaction reports, you can also save the reports as an Excel, PDF or XPF file.

          In Building Export Report


    • Related Articles

    • Professional Report Client Setup

      1.0 Introduction The system has a built-in report designer that allows you to create a new report from scratch or to modify any of the default reports. You can change fonts, add your own logo, change header and footer text, add a barcode field to the ...

    • Professional Report Client Data Sheet

      Attached.

    • Automatically Export an Attendance Report

      1.0 Introduction This setup example explains how to automatically export a report which lists the cardholders that have badged their cards at some point during the day. For this you need to have three Licensed Features enabled in your license: Host ...

    • Reports - Automatically Export an Attendance Report

      1.0 Introduction This setup example explains how to automatically export a report which lists the cardholders that have badged their cards at some point during the day. For this you need to have three Licensed Features enabled in your license: Host ...

    • Reports - Transactions

      Effective from version 3.5.1.22, a series of improvements have been made to simplify and speed up the process of creating transaction reports. Most noticeably is the report wizard, which replaces the previous method of selecting your report criteria ...