You can format the cells as custom (e.g., m/d/yyyy h:mm AM/PM) have the
user enter data as 8/5/2005 9:05. This will store as 8/5/2005 9:05 AM.
Have the output cell set as custom hh:mm:ss.


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