Re: $$Excel-Macros$$ Extract from date and time
for only date use int() and time use mod fuction On Tue, Oct 18, 2011 at 3:02 PM, Muhammad Arslan arslanacca...@gmail.comwrote: Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formual. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Extract from date and time
Hello Arslan; If you have real dates time, doesn't need MOD function. A1 = some date time; eg: 4/11/2011 08:39:20 PM Use in B1 for date, format as date =INT(A1) Use in C1 for time; format as time =A1-B1 HTH Haseeb -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Extract from date and time
Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formuale. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Extract from date and time
Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formual. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: [bulk] $$Excel-Macros$$ Extract from date and time
PFA Best Regards Momin Siraj Ahmad From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Muhammad Arslan Sent: 18 October 2011 01:32 PM To: excel-macros@googlegroups.com Subject: [bulk] $$Excel-Macros$$ Extract from date and time Importance: Low Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formual. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel DATE-TIME.xlsx Description: DATE-TIME.xlsx
Re: $$Excel-Macros$$ Extract from date and time
Are you SURE that it is TEXT and not time FORMATTED? Don Guillett SalesAid Software dguille...@gmail.com From: Muhammad Arslan Sent: Tuesday, October 18, 2011 4:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Extract from date and time Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formual. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Extract from date and time
Is this text string in an Excel Cell? or is it a text string from another source? More importantly, if it is in a cell, and you change the cell format to short date does it change? Are you wanting a cell formula, or a macro? What do you want to do with the separate values once you've extracted them? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Muhammad Arslan arslanacca...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, October 18, 2011 5:31:33 AM Subject: $$Excel-Macros$$ Extract from date and time Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formuale. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Extract from date and time
Hi, Assuming you have the data in cell a1, you can use following two formula for date n time respectively. =DATE(MID(A1,SEARCH(/,A1,SEARCH(/,A1)+1)+1,4),MID(A1,SEARCH(/,A1)+1,(SEARCH(/,A1,SEARCH(/,A1)+1)-SEARCH(/,A1)-1)),LEFT(A1,SEARCH(/,A1)-1)) =TIME(MID(A1,SEARCH( ,A1)+1,SEARCH(:,A1)-SEARCH( ,A1)-1),MID(A1,SEARCH(:,A1)+1,SEARCH(:,A1,SEARCH(:,A1)+1)-SEARCH(:,A1)-1),MID(A1,SEARCH(:,A1,SEARCH(:,A1)+1)+1,SEARCH(M,A1)-SEARCH( ,A1,SEARCH( ,A1)+1))) Sample file attached for your quick review. Regards, DILIPandey On 18 Oct 2011 18:59, Muhammad Arslan arslanacca...@gmail.com wrote: -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Extracting Date Time by DILIPandey.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Extract from date and time
Hi, Lot of option you as suggested by many expert. if the data need to extract to 2 different formt.. Use below formualeInt( a1)Date and Mod(a2,1)---time...change the format of cell as required. Happy learning Regards Chethan Kumar BN On Tue, Oct 18, 2011 at 3:02 PM, Muhammad Arslan arslanacca...@gmail.comwrote: Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formual. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- B.N Chetan kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel