Follow
Actual Time Calculation in a Report

The Text Mode code in this article can be used in order to get the actual time spent working on an object. The code subtracts Actual Start Date of an object from Actual Completion Date.

The syntax is as follows:
valueexpression=DATEDIFF({actualCompletionDate},{actualStartDate})

This returns full decimal places such as: 105.20822225694444
 
Another option is to ROUND the results
valueexpression=ROUND(DATEDIFF({actualCompletionDate},{actualStartDate}))
 
This rounds the results to: 105
 
STEPS
  • Edit a report
  • + Add Column
  • Switch to Text Mode
  • Copy the below four lines and Save the report.
displayname= Entry to Completion (or whatever column name you want)
textmode=true
valueexpression=ROUND(DATEDIFF({actualCompletionDate},{actualStartDate}))
valueformat=HTML
 
This article last updated on 2018-02-16 22:38:43 UTC