One way ... wherever you refer to the date/time in Col A, to be e.g.
=A5+Time(1,0,0). That will add the hour, then when you apply a
function like Day, it will use the adjusted date/time instead of the
original.
Rgds,
ScottO

"kdp145" wrote
in message
...
|
| 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
|