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.
Access requirements
You must have the following access to perform the steps in this article:
*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:
-
Go to a list of timesheets, or create a Timesheet Report.
For information about creating reports, see the article Create a custom report.
-
Click Customize View in a list of timesheets.
Or
Select the Columns (View) tab in a Timesheet report.
-
Click Add Column.
-
Click Switch to Text Mode.
-
In the Show in this column area, click Click to edit text.
-
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. -
Click Save, then name the new view and click Save View in a list of timesheets.
Or
Click Save + Close in a Timesheet report.
-
(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.