Knowledge Base

Home > Miscellaneous > Microsoft Excel: Convert ISO 8601 string to date type

Created
Modified

Print Article

Article 2684

Microsoft Excel: Convert ISO 8601 string to date type

Assuming that the first column contains the combined date time in the ISO 8601 format. For example:
2014-05-29T02:50:28
 
To convert the date time string into a date column:
  1. Enter the following formula into the first cell of an empty column:
    =DATEVALUE(MID(A1,1,10))+TIMEVALUE(MID(A1,12,8))
  2. Select the cell and drag the fill handle to the end of the column
  3. Right-click on the column header and select Format Cells...
  4. Select any of the available Date formats

Keywords

Related Articles


Please choose 1 to 5 whether this article solves your problem.

1 No Help at all

5 Problem Solved

Saving...
Thank you for your feedback.

What do you think about this topic? Send feedback!