Hi,
I have a file with many rows of time data in the format below:
<colgroup><col></colgroup><tbody>
</tbody>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:
2018-07-06T08:05:02.000+1000 |
2018-07-06T08:05:04.000+1000 |
2018-07-06T08:05:06.000+1000 |
2018-07-06T08:05:07.000+1000 |
2018-07-06T08:05:08.000+1000 |
2018-07-06T08:05:08.000+1000 |
2018-07-06T08:05:08.000+1000 |
2018-07-06T08:05:08.000+1000 |
2018-07-06T08:05:08.000+1000 |
2018-07-06T08:05:11.000+1000 |
2018-07-06T08:05:13.000+1000 |
2018-07-06T08:05:16.000+1000 |
2018-07-06T08:05:19.000+1000 |
2018-07-06T08:05:21.000+1000 |
2018-07-06T08:05:21.000+1000 |
2018-07-06T08:05:23.000+1000 |
2018-07-06T08:05:24.000+1000 |
2018-07-06T08:05:26.000+1000 |
2018-07-06T08:05:29.000+1000 |
2018-07-06T08:05:31.000+1000 |
2018-07-06T08:05:38.000+1000 |
2018-07-06T08:05:39.000+1000 |
2018-07-06T08:05:40.000+1000 |
2018-07-06T08:05:41.000+1000 |
<colgroup><col></colgroup><tbody>
</tbody>
Preferably via a formula. Alternatively or as well to unix epoch time.
That would be a big help.
Thank you,
Alfie101