Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split a date/time column into 2 columns
I want to split a date/time column ie. mm/dd/yy hh:mm:ss AM/PM. Into 2
columns 1. mm/dd/yy and 2. hh:mm I'm using excel 2003 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split a date/time column into 2 columns
1. =int(A1), format as date
2. =MOD(A1,1), format as time -- Kind regards, Niek Otten "RKMiller" wrote in message ... I want to split a date/time column ie. mm/dd/yy hh:mm:ss AM/PM. Into 2 columns 1. mm/dd/yy and 2. hh:mm I'm using excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Combining mutiple columns into one column | Excel Worksheet Functions | |||
Stack multiple columns into one column... is there an easy way? | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
How to split one column into two? | Excel Worksheet Functions |