---
schema_version: "1"
id: 6ffb573d63fcf20dd998b1544694b48b2da2f6ea7508a45a784415f5273594bb
title: Run an Over or Under Hours Report
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/aslm_tmsht_run_over_under_report.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.aslm_tmsht_run_over_under_report.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e6b168952cee0fa9a03e81c16beb679db0fa599a0f82dddcf31a344037147472
description: For teams that require technicians to work a certain number of hours per week, supervisors can create an Over or Under Hours report which includes the details of the total hours of each technician.
products:
  - Industry Solutions
  - Cross Cloud
release: "264"
---
# Run an Over or Under Hours Report

For teams that require technicians to work a certain number of hours per week, supervisors can create an Over or Under Hours report which includes the details of the total hours of each technician.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col style="width:100%"></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: All editions of Field Service Plus for Energy &amp; Utilities, and all editions of Asset Service Lifecycle Management</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d19866e61">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d19866e61 ">To access Timesheets objects:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d19866e61 ">Labor Cost Optimization Supervisor</td>

          </tr>
        </tbody>
      </table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:16.666666666666664%">
          <col style="width:33.33333333333333%">
          <col style="width:16.666666666666664%">
          <col style="width:33.33333333333333%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d19866e99">Report Name</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d19866e102">Business Type</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d19866e105">Custom Report Type</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d19866e108">Key Columns</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Report Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d19866e99 ">Over or Under 40 Report</td>

            <td data-label="Business Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d19866e102 ">The report shows if each technician met the 40-hour weekly target. It also
              shows if they exceeded or fell short of the target. Conditional formatting
              highlights any shortfalls or excesses for quick review. This is helpful before
              payroll approval. </td>

            <td data-label="Custom Report Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d19866e105 ">Time Sheet → Time Sheet Wage Type Summary (no new type needed)
            </td>

            <td data-label="Key Columns" class="slds-cell-wrap" style="vertical-align:top;" headers="d19866e108 "><a name="aslm_tmsht_run_over_under_report__ul_report_columns"><!-- --></a>
              <ul id="aslm_tmsht_run_over_under_report__ul_report_columns">
                <li>Service Resource Name (grouped)</li>

                <li>Time Sheet ID</li>

                <li>Start Time</li>

                <li>End Time</li>

                <li>Regular Hours</li>

                <li>Time-and-a-Half Hours</li>

                <li>Double-Time Hours</li>

                <li>Unpaid Hours</li>

                <li>Total Duration (Hours) - subtotal conditionally formatted (green &gt; 40 hrs and red
                  &lt; 40 hrs)</li>

              </ul>
            </td>

          </tr>
        </tbody>
      </table>

1. From the App Launcher, find and select **Reports** and click **New Report**.
2. Select **Time Sheet and Wage Type Summary** as the report type.
    
    If the report type does not exist, ask your system administrator to add a new report type.
3. Add the following key columns.
    
    - Service Resource Name (grouped)
    - Time Sheet ID
    - Start Time
    - End Time
    - Regular Hours
    - Time-and-a-Half Hours
    - Double-Time Hours
    - Unpaid Hours
    - Total Duration (Hours) - subtotal conditionally formatted (green > 40 hrs and red < 40 hrs)
4. Add the required filters.
    
    - Time Sheet Start Date Time
    - Service Resource Name
5. Click **Save & Run**.