/*]]>*/ skip to main content

2.4 How can I display seconds in the columns below the "timeStamp" field in Excel?

Solution:
When opening the CSV file by double-clicking, Excel formats time without seconds by default. Change the formatting of the column „timeStamp“ according to the pattern „TT.MM.YYYYY hh:mm:ss“ so that you can also see the seconds. Here you will find step-by-step instructions.

 

Tip:
Do not open CSV files by double-clicking, but use the import function of Excel. The import settings should have the cell type Text, not Standard. Also select semicolon as separator and UTF-8 as character encoding.
You can find a more detailed guide on that topic here:

Open UTF-8 encoded CSV files in Excel


(http://www.rechtsmedizin.med.uni-muenchen.de/service/anleitungen_hilfe/excel_csv_utf8/index.html).