Expand my Community achievements bar.

Task Report calculated field question


Level 1

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.)

2 Replies


Level 1

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. 


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??


displayname=Due Date