View: calculate overtime cost in a Timesheet View

Overtime is not calculated by default in Adobe Workfront, but you can create a Timesheet report that calculates overtime.

If the user is associated with a Cost per Hour rate in their profile, you can also calculate the amount of cost for the overtime of that user.
For information about associating users with Cost per Hour rates, see the article Configure My Settings.

NOTE
The Overtime field that you can add to a Timesheet view in a list or a report displays the information found in the Overtime field of the timesheet. This information is updated manually by a user with access to modify the timesheet. For more information about the Overtime field in a timesheet, see the article Timesheet layout overview.

Access requirements

You must have the following access to perform the steps in this article:

Adobe Workfront plan*
Any
Adobe Workfront license*

Request to modify a view

Plan to modify a report

Access level configurations*

Edit access to Reports, Dashboards, Calendars to modify a report

Edit access to Filters, Views, Groupings to modify a view

NOTE

If you still don’t have access, ask your Workfront administrator if they set additional restrictions in your access level. For information on how a Workfront administrator can modify your access level, see Create or modify custom access levels.

Object permissions

Manage permissions to a report

For information on requesting additional access, see Request access to objects.

*To find out what plan, license type, or access you have, contact your Workfront administrator.

Calculate overtime cost in a Timesheet View

To add a calculated Overtime column to a timesheet view:

  1. Go to a list of timesheets, or create a Timesheet Report.

    For information about creating reports, see the article Create a custom report.

  2. Click Customize View in a list of timesheets.

    Or

    Select the Columns (View) tab in a Timesheet report.

  3. Click Add Column.

  4. Click Switch to Text Mode.

  5. In the Show in this column area, click Click to edit text.

  6. Copy and paste the following text mode code in the Text mode dialog box.

    displayname=Calculated Overtime Cost
    linkedname=direct
    namekey=totalHours
    querysort=totalHours
    textmode=true
    valueexpression=IF({totalHours}>40,({totalHours}-40)*{user}.{costPerHour},{totalHours}*{user}.{costPerHour})
    valueformat=currencyStringCurrencyRounded
    
    note note
    NOTE
    This calculation assumes that the user usually works a 40-hour week.
  7. Click Save, then name the new view and click Save View in a list of timesheets.

    Or

    Click Save + Close in a Timesheet report.

  8. (Optional and conditional) if you are building a Timesheet report, specify a name for the report, then click Save Report.

    The cost of the overtime of each user is displayed in the Calculated Overtime Cost column.

    calculated_overtime_cost_in_timesheet_report.png

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43