Translations:Zeitstempel-Formate/6/en: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(Die Seite wurde neu angelegt: „== Microsoft Excel == === UNIX Timestamp === * Export your data in emoTouch with the option ''UNIX Timestamp''. * Load and open the Excel template ''emoTouch…“) |
Fgehrs (Diskussion | Beiträge) |
||
| Zeile 2: | Zeile 2: | ||
=== UNIX Timestamp === | === UNIX Timestamp === | ||
* Export your data in emoTouch with the option ''UNIX Timestamp''. | * Export your data in emoTouch with the option ''UNIX Timestamp''. | ||
| − | * Load and open the Excel template ''emoTouch Import''. | + | * Load and open the Excel template ''[[Media:EmoTouch_Import.xlsx|emoTouch Import]]''. |
* Import the emoTouch export file using the ''Import/Text File'' option (not the CSV option). | * Import the emoTouch export file using the ''Import/Text File'' option (not the CSV option). | ||
* You do not need to change the default settings of the import dialog. Import the data to a new sheet in the same workbook. | * You do not need to change the default settings of the import dialog. Import the data to a new sheet in the same workbook. | ||
Version vom 1. Juli 2022, 11:57 Uhr
Microsoft Excel
UNIX Timestamp
- Export your data in emoTouch with the option UNIX Timestamp.
- Load and open the Excel template emoTouch Import.
- Import the emoTouch export file using the Import/Text File option (not the CSV option).
- You do not need to change the default settings of the import dialog. Import the data to a new sheet in the same workbook.
- EXCEL displays the long numbers of the Unix timestamp in scientific notation by default (1.6xxxxE+12). This prevents you from seeing the relevant end of the timestamp with the last three numbers representing milliseconds. To change this, select the column containing the timestamp and apply the "UNIX Timestamp" cell template that comes with the template.
- To convert the UNIX Timestamp to a readable Date_Time format, copy the formula in the "Date_Time" column of the "Templates" sheet and copy it to an empty column of the sheet containing your imported emoTouch data. You may need to adjust the reference to the Unix timestamp column in the formula (E by default). If you see only one row of hashtags (######), the column is simply not wide enough to display the contents.
- To change the format of the date_time column, you can select another option in the cell styles dialog or create your own format.