Follow
How to calculate Overtime in a Timesheet Report

Question

Overtime is not calculated automatically in WF. Is there a way?

Answer

Using the following Textmode, you are able to do this in a Timesheet Report. Copy and paste the 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