update:
ok so i found the problem that was causing the date to change to
1/0/00. i did not tell you guys that i was actually rounding the time
by quarter hour and then adding an hour.

the problem is when i round the time to quarter hour, the date changes
to 1/0/00. so the problem with the dates is because of the rounding and
not becasue of adding an hour.

just to test, i tried adding a hour and that indeed changed the date.


--
kdp145
------------------------------------------------------------------------
kdp145's Profile: http://www.excelforum.com/member.php...o&userid=29594
View this thread: http://www.excelforum.com/showthread...hreadid=492953