Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split the date & time in one cell to be 2 colums.
I want to split the date & time in one cell to be 2 colums; Date and another
colum is Time. i.e. 4/11/2006 14.30 How should I do? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split the date & time in one cell to be 2 colums.
In A1: =TODAY()
format dd/mm/yyyy in B1: =NOW()-TODAY() format hh:mm:ss HTH -- AP "Aom" a écrit dans le message de ... I want to split the date & time in one cell to be 2 colums; Date and another colum is Time. i.e. 4/11/2006 14.30 How should I do? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split the date & time in one cell to be 2 colums.
If the entry is 4/11/2006 14:30 where time is 14:30 (not 14.30)...
B2: =INT(A2) C2: =A2-B2 Format B2 as date and C2 as time. Aom wrote: I want to split the date & time in one cell to be 2 colums; Date and another colum is Time. i.e. 4/11/2006 14.30 How should I do? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split the date & time in one cell to be 2 colums.
=INT(A2)
and =MOD(A2,1) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Aom" wrote in message ... I want to split the date & time in one cell to be 2 colums; Date and another colum is Time. i.e. 4/11/2006 14.30 How should I do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split date and time | Excel Discussion (Misc queries) | |||
Split combined date time data | Excel Discussion (Misc queries) | |||
Split combined date time data | Excel Discussion (Misc queries) | |||
Split combined date time data | Excel Discussion (Misc queries) | |||
split combined Time Date cells | Excel Discussion (Misc queries) |