Date and time
 

Hi all,

I've got a worksheet containing multiple columns with data. One of the rows
is a combination of yyyy/mm/dd/hr/mn/sd (20080908081442) except form '/'.
Excel also indicates the data in this column with an error indicator. However
when I use text to columns or format cells the desired result, creating a
clear view of the date and time (2008/09/08 08:14:42), is not managed. Anyone
has an idea how to solve this?!

Thnx

Date and time
 

=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))+TEXT(RIG HT(A1,6),"00\:00\:00")

--
__________________________________
HTH

Bob

"Basta1980" wrote in message
...
Hi all,

I've got a worksheet containing multiple columns with data. One of the
rows
is a combination of yyyy/mm/dd/hr/mn/sd (20080908081442) except form '/'.
Excel also indicates the data in this column with an error indicator.
However
when I use text to columns or format cells the desired result, creating a
clear view of the date and time (2008/09/08 08:14:42), is not managed.
Anyone
has an idea how to solve this?!

Thnx

Date and time
 

or =--TEXT(A1,"0000\/00\/00 00\:00\:00")
--
David Biddulph

"Bob Phillips" wrote in message
...
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))+TEXT(RIG HT(A1,6),"00\:00\:00")

--
__________________________________
HTH

Bob

"Basta1980" wrote in message
...
Hi all,

I've got a worksheet containing multiple columns with data. One of the
rows
is a combination of yyyy/mm/dd/hr/mn/sd (20080908081442) except form '/'.
Excel also indicates the data in this column with an error indicator.
However
when I use text to columns or format cells the desired result, creating a
clear view of the date and time (2008/09/08 08:14:42), is not managed.
Anyone
has an idea how to solve this?!

Thnx