View: calculate overtime cost in a Timesheet View

Last update: November 4, 2024

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:

Adobe Workfront planAny
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 permissionsManage 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:

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

Previous pageView: baseline variance for Duration and Planned Work in a task View
Next pageView: calculate time and date differences

Workfront