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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract Date from text 2
Extract Month and year from Cell containing date, month, year & time 2
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
date & Time 1
Please help: Extract some information from a cell 2
Extract Date formula Only 8
Extracting just the time portion 6
Extract Alphabets and Numbers from a Cell 6

Top