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
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
--
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
--
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
--
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
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
-
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
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(
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