Parsing an ISO8601 date/time (including TimeZone) in Excel

by

There is a (reasonably) simple way to parse an ISO timestamp WITHOUT the time zone using formulas instead of macros. This is not exactly what the original poster has asked, but I found this question when trying to parse ISO timestamps in Excel and found this solution useful, so I thought I would share it here.

The following formula will parse an ISO timestamp, again WITHOUT the time zone:

=DATEVALUE(MID(A1,1,10))+TIMEVALUE(MID(A1,12,8))

This will produce the date in floating point format, which you can then format as a date using normal Excel formats.

More Related Contents:

  1. Get Timezone Information in VBA (Excel)
  2. Excel Number Separation [closed]
  3. excel vba compare & copy worksheets from 2 excel files
  4. VBA Stuck after certain loop
  5. How to avoid using Select in Excel VBA
  6. Is the . in .Range necessary when defined by .Cells?
  7. How to return a result from a VBA function
  8. Cycle through sub-folders and files in a user-specified root directory [duplicate]
  9. Convert Text to Date?
  10. Loop through each cell in a range of cells when given a Range object
  11. Checking for #N/A in Excel cell from VBA code
  12. Non-web SQL Injection
  13. If WorkSheet(“wsName”) Exists [duplicate]
  14. How to merge rows in a column into one cell in excel?
  15. Autofilter with column formatted as date
  16. Excel vba refresh wait
  17. Excel vba to create every possible combination of a Range
  18. Excel VBA: getting row of clicked button [duplicate]
  19. Excel VBA Filter Change event handler
  20. How to copy only values in excel vba from a range?
  21. Run a Macro from Another Workbook
  22. Cannot VBA write data to cells in Excel 2007/2010 within a function
  23. Sorting a dictionary by key in VBA
  24. Handle “No cells were found” error when filtered range is empty
  25. Excel: the Incredible Shrinking and Expanding Controls [closed]
  26. How to send email to multiple recipients with addresses stored in Excel?
  27. Generate Word Documents (in Excel VBA) from a series of Document Templates
  28. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  29. Function Overloading and UDF in Excel VBA
  30. VBA Excel simple Error Handling

Leave a Comment