Please help: Extract some info. from a cell

B

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

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
 
Top