You evidently added an hour to a cell that contained only the time, 11:52 PM,
without the date. My instructions were to add an hour to the cell that
contains BOTH the date and the time.

On Tue, 13 Dec 2005 08:23:48 -0600, kdp145
wrote:


ok i did the exact same thing before adding the hour to the original
field thinking that it was going to add a day automatically if i added
the hour...but it doesnt.

i took column A and added a hour and formatted it as time so it changed
from 11:52 PM to 12:52 PM.

Now i took this column and formatted it as date and got 1/1/00 instead
of 12/13/05.