Please help: Extract some info. from a cell

[Bobsus5]

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!

[Ryan Poth]

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