Please help: Extract some info. from a cell
 

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=519588

Please help: Extract some info. from a cell
 

If your date/time value is in cell A1, you can use:
=A1-INT(A1)
and format it with a time format

or if it is only a display issue, simply format A1 with a time format to
display only the time.

HTH,
Ryan

"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=519588