| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
Linear Mode
