Re: $$Excel-Macros$$ Need Help to seperate Date & time

2013-01-10 Thread kumar.ashish861
Dear Senior, Thanks for your reply & support. I'll keep this in my mind for better future assistance. Thanks Ashish kumar On Thursday, January 10, 2013 1:03:01 PM UTC+5:30, Ms-Exl-Learner wrote: > > Please make it in an excel workbook and send it to us for our better > understanding of your

Re: $$Excel-Macros$$ Need Help to seperate Date & time

2013-01-10 Thread kumar.ashish861
Dear Noorain Sir, Thanks for your valuable support. Thanks Ashish Kumar On Thursday, January 10, 2013 1:13:59 PM UTC+5:30, NOORAIN ANSARI wrote: > > Dear Ashish, > > You can try,, > > > For date > =date(year(a1),month(a1),day(a1) > and press ctrl+shift+# > > For time > =date(Hour(a1),minute(a1)

Re: $$Excel-Macros$$ Need Help to seperate Date & time

2013-01-09 Thread NOORAIN ANSARI
Dear Ashish, You can try,, For date =date(year(a1),month(a1),day(a1) and press ctrl+shift+# For time =date(Hour(a1),minute(a1),second(a1) and press ctrl+shift+@ On Thu, Jan 10, 2013 at 1:01 PM, kumar.ashish861 wrote: > Dear Seniors, > > Pls help to seperate date & time, if both are in 1 cell.

Re: $$Excel-Macros$$ Need Help to seperate Date & time

2013-01-09 Thread Ms-Exl-Learner
Please make it in an excel workbook and send it to us for our better understanding of your data structure. On 10-01-2013 1:01 PM, kumar.ashish861 wrote: Dear Seniors, Pls help to seperate date & time, if both are in 1 cell. 7/11/2012 13:51 Formula req..! Thanks in advance Ashish k