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

Avatar

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

Avatar

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. 

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