Extracting partial information from a cell

  • Thread starter Thread starter Jode
  • Start date Start date
J

Jode

I have a speadsheet and one of the cells has the date and time. I want to
know can you pull the time part of this cell and imput into another cell???
 
If you have a true Excel date/time, you can separate them with:
date: =int(a1)
time: =mod(a1,1)

Change a1 to your actual cell address.

If this doesn't work for you, then you don't have a date/time, you have
text. Show us examples of what you have, and how you want it "pulled apart".
Be sure to identify how you want the result stored (eg, date, time, text)

Regards,
Fred
 

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

Pulling a specific email from cells and putting info in new row 4
how to change multiple cell comment properties? 1
Excel Sum numbers in cells that also contain text 34
data from multiple files: best way to extract 1
Partial cell protection? 1
How to filter rows data based on background color of individual cells 1
Number Formatting 1
Combining Letters and Numbers 1

Back
Top