Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting date and time information in cells
I have cells with the following info:
4/14/2003 14:35 but i need to split so that i can sort by date alone. how can this be done? i have tried just taking out the data, but that just treats the "/" as a dividing sign and so get weird numbers. thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting date and time information in cells
If these are real dates/times, you could use:
=int(a1) to get the date -- format it as a date. and if you wanted =mod(a1,1) to get the time -- format it as time mebsmith wrote: I have cells with the following info: 4/14/2003 14:35 but i need to split so that i can sort by date alone. how can this be done? i have tried just taking out the data, but that just treats the "/" as a dividing sign and so get weird numbers. thanks in advance -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting date and time information in cells
=Int(A1) ' provides Date
=A1-Int(A1) ' provides Time "mebsmith" wrote in message ... I have cells with the following info: 4/14/2003 14:35 but i need to split so that i can sort by date alone. how can this be done? i have tried just taking out the data, but that just treats the "/" as a dividing sign and so get weird numbers. thanks in advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting date and time information in cells
"mebsmith" wrote: I have cells with the following info: 4/14/2003 14:35 but i need to split so that i can sort by date alone. I also have cells with dates in the form: 20030416000927 where the date is the first 8 numbers. How can i extract that out? Thanks how can this be done? i have tried just taking out the data, but that just treats the "/" as a dividing sign and so get weird numbers. thanks in advance |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting date and time information in cells
DataText to ColumnsFixed width.
Drop a line down after the 8th digitNext Column Data formatdateYMD Select right column and "do not import" then Finish. Gord Dibben MS Excel MVP On Tue, 26 Aug 2008 12:17:04 -0700, mebsmith wrote: "mebsmith" wrote: I have cells with the following info: 4/14/2003 14:35 but i need to split so that i can sort by date alone. I also have cells with dates in the form: 20030416000927 where the date is the first 8 numbers. How can i extract that out? Thanks how can this be done? i have tried just taking out the data, but that just treats the "/" as a dividing sign and so get weird numbers. thanks in advance |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting date and time information in cells
thanks!
"Gord Dibben" wrote: DataText to ColumnsFixed width. Drop a line down after the 8th digitNext Column Data formatdateYMD Select right column and "do not import" then Finish. Gord Dibben MS Excel MVP On Tue, 26 Aug 2008 12:17:04 -0700, mebsmith wrote: "mebsmith" wrote: I have cells with the following info: 4/14/2003 14:35 but i need to split so that i can sort by date alone. I also have cells with dates in the form: 20030416000927 where the date is the first 8 numbers. How can i extract that out? Thanks how can this be done? i have tried just taking out the data, but that just treats the "/" as a dividing sign and so get weird numbers. thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting information in cells | Excel Worksheet Functions | |||
Splitting Date and Time | Excel Discussion (Misc queries) | |||
Sumif a date time colum and information | Excel Discussion (Misc queries) | |||
How do place a column of date/time information into a calendar for | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) |