Task Report calculated field question

Question

Hello, I'm looking to create a calculated field on a task report.
 
I would like the calculation to be task handoff date + task duration and the result to show in date and time format.
 
 I cant seem to find a field that gives me this without the dates moving to the next business day if a task is late (projected completion date, etc.)

steveb25 · Answer

I came up with the below calculation which seems to work, but when my duration has a decimal (.5 days, 1.5 days) the calculation doesn't notice the .5, it rounds down to day.

Example:

Handoff date - 12/19 10 am

Duration - 1.5 days

Calculation - 12/20 10 am

Thoughts on how I get the system to notice the decimal??

valueexpression=ADDWEEKDAYS({handoffDate},({plannedDurationMinutes}/480))
textmode=true
valueformat=longAtDate
displayname=Due Date

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded