Follow
Calculating Overtime in a Timesheet Report

Problem

Overtime is not calculated by default in Workfront.

Solution

Using Textmode, you can create a Timesheet report that calculates overtime.

  1. Create a Timesheet Report.
    For information about creating reports, see "Creating a Report."
  2. Copy and paste the following Textmode code into a blank column in a report.
    displayname=
    linkedname=direct
    namekey=totalHours
    querysort=totalHours textmode=true
    valueexpression=IF({totalHours}>40,(({totalHours}-40)*1.5+40)*{user}.{costPerHour},{totalHours}*{user}.{costPerHour})
    valueformat=currencyStringCurrencyRounded
  3. Save and close the report.
This article last updated on 2018-03-06 19:27:25 UTC