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
--
-
The best Answer so far by XLS S!
On Oct 20, 1:24 pm, XLS S wrote:
> for only date use int()
> and time use mod fuction
>
> On Tue, Oct 18, 2011 at 3:02 PM, Muhammad Arslan
> wrote:
>
>
>
>
>
>
>
> > Dear Experts
> > I need to disjoint date and time form a text. Help me out how to tackle in
> > e
for only date use int()
and time use mod fuction
On Tue, Oct 18, 2011 at 3:02 PM, Muhammad Arslan wrote:
>
>
>
> 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
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 w
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
” - John Wesley
-
From: Muhammad Arslan
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
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
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 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
--
10 matches
Mail list logo
