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