I try to perform a calculation of the start time and finished time. The
start time will be automatic put in by system using now() function and
the finish time will be put in by user. The problem is when user enter
the time the date is always 1/0/1900 10:18:48 AM, which make the
calculation negative. Is there anyway to overcome this problem.


--
canix
------------------------------------------------------------------------
canix's Profile: http://www.excelforum.com/member.php...o&userid=25962
View this thread: http://www.excelforum.com/showthread...hreadid=393333