| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting partial information from a cell
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??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting partial information from a cell
One way:
=MOD(A1,1) Format as Time -- Biff Microsoft Excel MVP "Jode" wrote in message ... 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??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting partial information from a 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 "Jode" wrote in message ... 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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling partial information from a cell | Excel Worksheet Functions | |||
| Deleting partial information from all cells in a column | Excel Worksheet Functions | |||
| extracting information from a certain place in one cell | Excel Discussion (Misc queries) | |||
| merging information from partial duplicate rows | Excel Discussion (Misc queries) | |||
| Extracting cell information from various sheets to a master list | Excel Discussion (Misc queries) | |||
Linear Mode
