获取LibreOffice Calc或Excel导入ISO8601日期时间的最简单方法

Using Python3, I've made a bunch of log files, which include datetimes rendered with the iso_format() method. E.g.

使用Python3，我已经做了一堆日志文件，其中包括使用iso_format()方法呈现的日期时间。如。

...
2015-04-09T18:31:56.285000  12.7
2015-04-09T18:31:56.285000  12.6
2015-04-09T18:32:16.662000  12.8
2015-04-09T18:32:36.231000  12.4
2015-04-09T18:32:56.235000  12.6
2015-04-09T18:33:56.242000  12.8
...

I want to import these into either Excel (Excel 2011 for Mac, version 14.4.8) or Calc (LibreOffice 4.4.2.2).

我想将它们导入到Excel (Mac的Excel 2011, 14.4.8版)或Calc (LibreOffice 4.2.2)中。

I am frustrated that neither of these supports IS8601 right out of the box, especially surprised about Calc given its open source lineage. I have to believe that there are plenty of analysts out there though that need to import data from IS8601 datasets and analyze it in either of these programs.

我感到沮丧的是，这两种方法都不支持IS8601，尤其是考虑到Calc的开源血统。我不得不相信有很多分析师需要从IS8601数据集中导入数据并在这些程序中进行分析。

What are they doing? What is the easiest way to get my ISO8601 fields interpreted quickly in either of these?

他们在做什么?用这两种方法快速解释ISO8601字段最简单的方法是什么?

1 个解决方案

#1

Please try:

请尝试:

=LEFT(A1,FIND("T",A1)-1)+MID(A1,FIND("T",A1)+1,LEN(A1))

and format as:

和格式为:

dd/mm/yyyy hh:mm:ss.000

or to suit.

或套装。

#1