i am pulling in a report which has a date and time of the entry in
Column A...for ex 12/12/05 11:52 PM.
I have another column (Column B) which pulls in the date from Column
A..so it would be 12/12/05.
Column C has the time...so it would be 11:52 PM.
But now I want to add an hour to the time...so 11:52 PM would become
12:52 AM.
This I can do, but since the day changed, I want to be able to change
the date from 12/12/05 to 12/13/05 in Column B.
So essentially in the original column, if the time is 11:00 PM (since I
will be adding a hour to make it 12:00 AM of next day) or later than I
want to add a day to Column B.
I tried an if statement, so if the time was 11:00 PM or later it would
add another day, but that only works for that day since Excel uses
serial numbers for date/time.
It probly is something simple, but I just cant figure it out.
--
kdp145
------------------------------------------------------------------------
kdp145's Profile:
http://www.excelforum.com/member.php...o&userid=29594
View this thread:
http://www.excelforum.com/showthread...hreadid=492953