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.)
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Bumping this thread. Any suggestions?
Views
Replies
Total Likes