I have in cell A1 19/04/05 23:10. in dd/mm/yy hh:mm format.
To convert only to date I have entered in B1 I have entered =a1*1
In C1 I have entered =b1 and formnatted to date.
Any idea how I can extract just the time.
The end result i am after is to seperate out the date & time to 2 seperate
cells.
Apologies if am convuluted but am new!!

To get the date only, use

=Int(A1)

To get the time only, use

=A1 - Int(A1)



"gb_S49" wrote:

I have in cell A1 19/04/05 23:10. in dd/mm/yy hh:mm format.
To convert only to date I have entered in B1 I have entered =a1*1
In C1 I have entered =b1 and formnatted to date.
Any idea how I can extract just the time.
The end result i am after is to seperate out the date & time to 2 seperate
cells.
Apologies if am convuluted but am new!!

Brilliant. Thank you

"Duke Carey" wrote:

To get the date only, use

=Int(A1)

To get the time only, use

=A1 - Int(A1)



"gb_S49" wrote:

I have in cell A1 19/04/05 23:10. in dd/mm/yy hh:mm format.
To convert only to date I have entered in B1 I have entered =a1*1
In C1 I have entered =b1 and formnatted to date.
Any idea how I can extract just the time.
The end result i am after is to seperate out the date & time to 2 seperate
cells.
Apologies if am convuluted but am new!!

"Duke Carey" wrote in message
...

To get the time only, use

=A1 - Int(A1)

=MOD(A1,1)

Hi,

Try this

In cell B1, enter TEXT(A1,"dd mm yy") for extracting the date and
TEXT(A1,"hh:mm") for extracting the time.

Regards,

"gb_S49" wrote:

I have in cell A1 19/04/05 23:10. in dd/mm/yy hh:mm format.
To convert only to date I have entered in B1 I have entered =a1*1
In C1 I have entered =b1 and formnatted to date.
Any idea how I can extract just the time.
The end result i am after is to seperate out the date & time to 2 seperate
cells.
Apologies if am convuluted but am new!!

Realized that about 2 seconds after hitting the Post button. Not enough
sleep last night <g



"Bob Phillips" wrote:


"Duke Carey" wrote in message
...

To get the time only, use

=A1 - Int(A1)

=MOD(A1,1)

Thanks to all for all your help

"gb_S49" wrote:

I have in cell A1 19/04/05 23:10. in dd/mm/yy hh:mm format.
To convert only to date I have entered in B1 I have entered =a1*1
In C1 I have entered =b1 and formnatted to date.
Any idea how I can extract just the time.
The end result i am after is to seperate out the date & time to 2 seperate
cells.
Apologies if am convuluted but am new!!

Too much time teading the NG boards <g


"Duke Carey" wrote in message
...
Realized that about 2 seconds after hitting the Post button. Not enough
sleep last night <g



"Bob Phillips" wrote:


"Duke Carey" wrote in message
...

To get the time only, use

=A1 - Int(A1)

=MOD(A1,1)