+ Reply to Thread
Results 1 to 3 of 3

Assistance with date conversion formula

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,176

    Assistance with date conversion formula

    I some assistance with converting a date based upon a time in column A

    I have a number of dates in column A as follows:

    01/13/2009 11:50 AM
    01/05/2009 09:14 AM
    01/12/2009 05:30 PM
    01/12/2009 02:30 PM
    01/12/2009 01:45 PM

    I need to convert these values to another date base upon the values in column A.

    If the time < 2:00 pm then leave date as is, if time > than 2:00 pm then add one day.

    The expected results in column B would be as follows

    01/13/2009
    01/05/2009
    01/13/2009
    01/13/2009
    01/12/2009

    Thanks for any comments
    Last edited by maacmaac; 01-15-2009 at 01:27 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Perhaps =INT(A1) + (MOD(A1,1) > "14:00" + 0)
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,176
    Perfect! Thanks for the quick solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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