How to subtract 15 minutes from Start Date column in Calendar

# How to subtract 15 minutes from Start Date column in Calendar

• Friday, August 06, 2010 2:47 AM

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

### All Replies

• Friday, August 06, 2010 3:28 AM

= [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
• Friday, August 06, 2010 2:46 PM

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