Category Archives: SharePoint

Calculated Column: Calculate the difference between two times

You can calculate the difference between the time an item is created and modified via the following formulas:

=TEXT([Modified]-[Created],”h”)¬†Displays the hours between the two times;

=TEXT([Modified]-[Created],”h:mm”) Displays the hours and minutes between the two times;

=TEXT([Modified]-[Created],”h:mm:ss”) Displays the hours, minutes and seconds between two times.

For the methods to work, hours must not exceed 24, and minutes and seconds must not exceed 60.

Calculated Column: Items created this week

An short post about how to create a view displaying the  list items that are created this week:

Create a calculated column named WeekStart and add the following formula =[Created]-(WEEKDAY([Created])-1)

Create a calculated column named WeekEnd and add the following formula =[Created]+(7-WEEKDAY([Created]))

Now create a view where there’s a filter that [Today] is bigger than or equal to WeekStart and a filter that [Today ] is less than or equal to WeekEnd