DocumentationWorkfrontWorkfront Guide

View: calculate overtime cost in a Timesheet View

Last update: Mon Nov 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User

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.

calculated_overtime_cost_in_timesheet_report.png

Access requirements

Expand to view access requirements for the functionality in this article.

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

table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header
Adobe Workfront plan Any
Adobe Workfront license*

New:

  • Contributor to modify a filter

  • Standard to modify a report

Current:

  • Request to modify a filter

  • 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 filter
Object permissions Manage permissions to a report

*For information, see Access requirements in Workfront documentation.

Calculate overtime cost in a Timesheet View

To add a calculated Overtime column to a timesheet view:

  1. Go to a list of timesheets.

  2. Click the View drop-down menu, then click New View.

  3. Click Add Column.

  4. Click Switch to Text Mode, then click Edit Text Mode.

  5. In the Edit Text Mode box, remove the text in the box, then copy and paste the following text mode code:

    code language-none 
    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.

  6. Click Done, then name the new view and click Save View in a list of timesheets.

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

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