Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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