I have a suggestion. I hope it may helps. Would you mind to try this ?
Put "=TIME(HOUR(N1),MINUTE(N1),)" in Cell S1.

"Bobsus5" wrote:


I have a cell that contains both a date and a time. I need to extract
only the time and put that into a new cell. Example: cell N1 reads
"01/19/06 12:53:32 PM". I only want to extract the time to put into
cell S1. What formula do I use to do this? THANK YOU!


--
Bobsus5
------------------------------------------------------------------------
Bobsus5's Profile: http://www.excelforum.com/member.php...o&userid=32210
View this thread: http://www.excelforum.com/showthread...hreadid=519590