Hi,
I have a file with many rows of time data in the format below:
[TABLE="width: 291"]
<colgroup><col></colgroup><tbody>[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
[TR]
[TD]
[/TR]
</tbody>[/TABLE]
I should like to know please how to convert it to a format preferably like this: day/month/year hours/mins/seconds/milliseconds
Preferably via a formula. Alternatively or as well to unix epoch time.
That would be a big help.
Thank you,
Alfie101
I have a file with many rows of time data in the format below:
[TABLE="width: 291"]
<colgroup><col></colgroup><tbody>[TR]
[TD]
2018-07-06T08:05:02.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:04.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:06.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:07.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:08.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:08.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:08.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:08.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:08.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:11.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:13.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:16.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:19.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:21.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:21.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:23.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:24.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:26.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:29.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:31.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:38.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:39.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:40.000+1000
[/TD][/TR]
[TR]
[TD]
2018-07-06T08:05:41.000+1000
[/TD]
[/TR]
</tbody>[/TABLE]
I should like to know please how to convert it to a format preferably like this: day/month/year hours/mins/seconds/milliseconds
Preferably via a formula. Alternatively or as well to unix epoch time.
That would be a big help.
Thank you,
Alfie101