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
Bookmarks