Introduction

SharePoint Lists support a number of functions from Excel.

Below shows how to calculate a new date derived from the value in the Start Time column.

————

Start Time is automatically created column when you create a SharePoint calendar.

If you want to calculate a value for a second date column offset from Start Time, (or any other time column such as End Time), you need to create a calculated column.

opcje binarne platforma Example 1 – calculate  78dde21fa4b7e515c92726e477130006 30 minutes before  corso avanzato opzioni digitali Start Time

Create a new column ‘ siti borsa sistema binario siti Reminder’ in the SharePoint list using  http://winevault.ca/?perex=demo-broker-opzioni-binarie Calculated column type and enter formula

=[Start Time]-1/48

using data type  http://www.polykani.cz/?indianapolis=dating-a-guy-with-a-crazy-ex-girlfriend&e11=56 Date and Time

The calculation is based on days, so for 30 minutes use 1 day divided by 48 = 30 minutes

Title Start Time Reminder < ‘Reminder’ function >
Job 1 01/08/2015 13:00 01/08/2015 12:30 =[Start Time]-1/48
Job 2 11/08/2015 18:45 11/08/2015 18:15 =[Start Time]-1/48
Job 3 14/08/2015 00:15 13/08/2015 23:45 =[Start Time]-1/48

http://yoursportsmarketing.com/piceria/1797 Example 2 – calculate http://www.chezlucas.fr/?rtywwew=exemple-de-phrase-site-de-rencontre&f4b=57 1 week before  watch Start Time

Create a new column ‘ enter site Reminder’ in the SharePoint list using  click Calculated column type and enter formula

=[Start Time]-7

using data type  http://blossomjar.com/pacinity/2114 Date and Time

Title Start Time Reminder < ‘Reminder’ function >
Job 1 01/08/2015 13:00 25/07/2015 13:00 =[Start Time]-7
Job 2 11/08/2015 18:45 04/08/2015 18:45 =[Start Time]-7
Job 3 14/08/2015 00:15 07/08/2015 00:15 =[Start Time]-7

 

Note: SharePoint calendar Start Time can’t be used in Workflows. If you want to trigger an action in a Workflow based on date and time you need to use the method described above to create a new reference column.