How to subtract 15 minutes from Start Date column in Calendar

Question

I have a calculated column in a Calendar List, where I need to subtract 15 minutes from the Start Date column.

Can anyone tell me what that formula would be?  All of the formulas I keep trying just come back with 12/30/1899 12:00 AM as the value.

Thank you.

---

Linda Chapman | SharePoint Consultant | My Blog: http://LindaChapman.BlogSpot.com | http://www.linkedin.com/in/LindaChapman

Answer 1

 

 = [Start Time] - (1/24/4)

or

 = [Start Time] - 0.010416667

And then set "The data type returned from this formula is" to  "Date and Time" and set "Date and Time Format" to "Date & Time"

 

In date / time math, 1 = one day, 1/24 = one hour, 1/24/4 = .25 of an hour, or 15 minutes  (or you could use 1/24/60*15)

 

---

Mike Smith TechTrainingNotes.blogspot.com

Answer 2

wow so easy, and I have been doing SharePoint for 6 years now and never new that. Thank you for your quick response!

---

Linda Chapman | SharePoint Consultant | My Blog: http://LindaChapman.BlogSpot.com | http://www.linkedin.com/in/LindaChapman