Formatting Timestamp - Need Assistance ! [CALC]

asked 2018-06-21 15:05:38 +0200

grantlandau gravatar image

updated 2018-06-26 17:11:25 +0200

I'm attempting to format a timestamp on a document that I received from a vendor.

FORMAT RECEIVED: 2016-01-04 15:33:47.000000 CET+0100

FORMAT CONVERTING TO: 2016-01-04 15:33:47 +0000

I can very easily format the column as text, but my database importer does not accept the formatting as text. I believe that I need to retain the timestamp formatting in LibreOffice, however I'm not very familiar with the process. I've done formatting changes for simple timestamps using HH:MM:SS etc. This format is a little more complicated -

Please help!

edit retag flag offensive close merge delete


How do you "receive" this data? Can you process the conversion before bringing into Calc? (And I assume this is about spreadsheet? You haven't tagged it with Calc, and you don't explicitly specify.)

David gravatar imageDavid ( 2018-06-21 19:26:03 +0200 )edit

First you must provide to us which is the "importer" and what the importer expects. Because the importer expects a type. For example may expects a text in format YYYYMMDD, or an integer starting from X day, etc. etc.

Xoristzatziki gravatar imageXoristzatziki ( 2018-06-22 07:28:49 +0200 )edit

I received this data as a CSV and imported to another program also as CSV. I don't know how to process it before moving it into calc, I don't really have any other editing software other than LibreOffice. The importer program is looking for YYYY-MM-DD HH:mm:ss Z as a format. The Z is the offset and I can't seem to get Libre to format the offset.

I initially just tried converting the data to text and doing a replace function, but csv doesn't work like that.

grantlandau gravatar imagegrantlandau ( 2018-06-26 17:10:18 +0200 )edit

When opening a CSV with Calc you can change the format of imported columns, by clicking on the sample column and changing the type of just this column. Have you tried this?

Xoristzatziki gravatar imageXoristzatziki ( 2018-06-26 21:47:09 +0200 )edit