i tried the formula you suggested, but they dont work....the date doesnt
change to the next day when anything greater than 11:46PM is incremented
to 12:00AM. the time doesnt work in some cases. for ex: if time is
11:23PM, it will increment it to 11:30PM, which is fine but if the time
is 11:30PM, it increments to 11:45PM instead of staying at 11:30PM.

anybody have any other suggestions?


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