left & right
 

Hi,
I need copy a part of a field setted as date/hour.
then if I had in a field:

16/12/2008 20.50

I need take in new fields:

A1: 16 (like number)
A2: 20.50
A3: 50 (that's the minutes)
A4: 12 ( that's the month)

anyone got any idea about?
thanks 4 ur precious help.

--
BBB

left & right
 

With your data presumed in A1, ie: 16/12/2008 20.50
try this battery in A2:A5
=LEFT(A1,SEARCH("/",A1)-1)+0
=MID(A1,SEARCH(" ",A1)+1,99)+0
=MID(A1,SEARCH(".",A1)+1,99)+0
=MID(A1,SEARCH("/",A1)+1,2)+0
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"Andrew" wrote:
I need copy a part of a field setted as date/hour.
then if I had in a field:

16/12/2008 20.50

I need take in new fields:

A1: 16 (like number)
A2: 20.50
A3: 50 (that's the minutes)
A4: 12 ( that's the month)

left & right
 

max,
thanks a lot.

--
BBB


"Max" wrote:

With your data presumed in A1, ie: 16/12/2008 20.50
try this battery in A2:A5
=LEFT(A1,SEARCH("/",A1)-1)+0
=MID(A1,SEARCH(" ",A1)+1,99)+0
=MID(A1,SEARCH(".",A1)+1,99)+0
=MID(A1,SEARCH("/",A1)+1,2)+0
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"Andrew" wrote:
I need copy a part of a field setted as date/hour.
then if I had in a field:

16/12/2008 20.50

I need take in new fields:

A1: 16 (like number)
A2: 20.50
A3: 50 (that's the minutes)
A4: 12 ( that's the month)

left & right
 

Welcome, pl press the YES button (like the one below) in that response. Thanks
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"Andrew" wrote:
max,
thanks a lot.

left & right
 

Hi

X1: 16/12/2008 20:50

A1: =DAY(X1)
A2: = MOD(X1,1) formatted as Custom "hh:mm"
A3: = MINUTE(X1)
A4: =MONTH(X1)


Arvi Laanemets



"Andrew" wrote in message
...
Hi,
I need copy a part of a field setted as date/hour.
then if I had in a field:

16/12/2008 20.50

I need take in new fields:

A1: 16 (like number)
A2: 20.50
A3: 50 (that's the minutes)
A4: 12 ( that's the month)

anyone got any idea about?
thanks 4 ur precious help.

--
BBB

left & right
 

thanks a lot to all.
--
BBB


"Arvi Laanemets" wrote:

Hi

X1: 16/12/2008 20:50

A1: =DAY(X1)
A2: = MOD(X1,1) formatted as Custom "hh:mm"
A3: = MINUTE(X1)
A4: =MONTH(X1)


Arvi Laanemets



"Andrew" wrote in message
...
Hi,
I need copy a part of a field setted as date/hour.
then if I had in a field:

16/12/2008 20.50

I need take in new fields:

A1: 16 (like number)
A2: 20.50
A3: 50 (that's the minutes)
A4: 12 ( that's the month)

anyone got any idea about?
thanks 4 ur precious help.

--
BBB