Toppers,
That is the formula that I was using.
It works only once, if more information is added to the sheet the time
changes for all of the fields (column B).
What I'm trying to do is to wand in when shipment order comes in A3
and have B3 indicate the day and time it was wanded in. Then wand in
the next shipment in A4 and have B4 indicate the day and time without
changing B3 and so forth.


--
BannerBrat
------------------------------------------------------------------------
BannerBrat's Profile: http://www.excelforum.com/member.php...fo&userid=5485
View this thread: http://www.excelforum.com/showthread...hreadid=532712