| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extracting time only
good morning
I have a seri of cells where the information inside is like 10/2/2007 4:38:00 PM I would like to create 2 columns where in one of them I have the date only and in the other I have the time only Any idea as to what is the best thing to ddo? Help is appreciated ... Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
extracting time only
You can get the date with:
=INT(A1) and the time with: =MOD(A1,1) if your date/time is in A1. Format the cells appropriately. Hope this helps. Pete On Apr 10, 4:34*pm, "Michel Khennafi" wrote: good morning I have a seri of cells where the information inside is like 10/2/2007 *4:38:00 PM I would like to create 2 columns where in one of them I have the date only and in the other I have the time only Any idea as to what is the best thing to ddo? Help is appreciated ... Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting First Name | New Users to Excel | |||
| Extracting Time from a cell that has both the date and the time | Excel Discussion (Misc queries) | |||
| Extracting time | Excel Discussion (Misc queries) | |||
| extracting last name | Excel Worksheet Functions | |||
| extracting dd from dd/mm/yy | Excel Worksheet Functions | |||
Linear Mode
