Posted by: R Manimaran | February 11, 2011

SharePoint Tasks List: Add a Duration Calculated Column

SharePoint Tasks List: Add a Duration Calculated Column

In SharePoint Task we have Start Date and Due Date. But there is no Duration Column (i..e Difference of Start Date and Due Date).

For that we can add a Calculated Column with formula to calculate this.

Formula:

=IF(OR(ISBLANK([Due Date]),ISBLANK([Start Date])),0,FIXED([Due Date]-[Start Date],0))

The duration column will be available in ViewForm only(not in NewForm or EditForm) as shown.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: