Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Task Report calculated field question

Avatar

Level 2

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 2

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

Avatar

Level 2

Bumping this thread. Any suggestions?