+ Reply to Thread
Results 1 to 3 of 3

sharepoint formula time and date calculation

  1. #1
    Forum Contributor
    Join Date
    05-09-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2016
    Posts
    543

    sharepoint formula time and date calculation

    I know it is not directly related but sharepoint and excel are similiar:

    I am trying to create a calculated column (Adjusted Date) that will add one day to [Date Received] if a sample is received on/after 12:00PM and on a Monday thru Thursday. add three days to [Date Received] if a sample is received on/after 12:00PM and on a Friday. Is the formula below close? Thank you.

    =IF(AND([Time Received]>=12:00PM,[Day Received]<4),[Date Received] +1), =IF(AND([Time Received]>=12:00PM,[Day Received]=5),[Date Received] +3).

    Thank you.

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: sharepoint formula time and date calculation

    12:00PM will be read by the formula as a string of text, which can't have any operators performed on it without an error occurring. try "12:00 PM" instead (including quotes)
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: sharepoint formula time and date calculation

    Or, use the decimal equivalent of 0.5.

    12:00 PM = 0.5
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED]Time/Date calculation to check response time
    By tailz in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-01-2013, 10:20 AM
  2. Replies: 6
    Last Post: 05-20-2013, 07:45 PM
  3. Calculation of time difference between the Start date & time & End Date & time
    By Harry Jones in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-17-2012, 03:54 PM
  4. Time calculation formula, how to stop it once date is entered.
    By twiles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2010, 11:38 AM
  5. formula date and time calculation
    By changetires in forum Excel General
    Replies: 7
    Last Post: 06-27-2006, 10:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1