Date and time

[Basta1980]

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

 

[Bob Phillips]

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

 

[David Biddulph]

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