| 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 | |||
Linear Mode
