{"id":330,"date":"2021-10-19T19:37:00","date_gmt":"2021-10-19T19:37:00","guid":{"rendered":"https:\/\/www.bjorn-meijer.nl\/?p=330"},"modified":"2021-11-02T20:39:21","modified_gmt":"2021-11-02T20:39:21","slug":"converteer-unix-tijdstempel-naar-excel-datum","status":"publish","type":"post","link":"https:\/\/www.bjorn-meijer.nl\/de\/2021\/10\/19\/konvertiere-unix-zeitstempel-in-excel-datum\/","title":{"rendered":"Konvertieren Sie Unix-Zeitstempel in Excel-Datum"},"content":{"rendered":"<h2 class=\"wp-block-heading\" id=\"h-wat-is-een-unix-tijdstempel\">Was ist ein Unix-Zeitstempel?<\/h2>\n\n\n\n<p>Ein Unix-Zeitstempel ist die Anzahl der Sekunden, die seit Mitternacht des 1. Januar 1970 vergangen sind. Dies beinhaltet keine Schaltsekunden.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-hoe-excel-met-datum-en-tijd-omgaat\">Wie Excel mit Datum und Uhrzeit umgeht.<\/h2>\n\n\n\n<p>Um einen Unix-Zeitstempel in ein lesbares Datum umzuwandeln, schauen wir uns zun\u00e4chst an, wie Excel mit Datumsangaben umgeht. Wie Sie oben gelesen haben, beginnt der Unix-Zeitstempel am 1. Januar 1970.<br>Excel begann am 1. Januar 1900 mit der Z\u00e4hlung von Daten. Excel liest das Datum als numerische Zahl. In der Tabelle unten sehen Sie das Datum in der linken Spalte, wie wir es lesen, in der rechten Spalte, wie Excel ein Datum liest.<\/p>\n\n\n\n<div class=\"wp-block-wpdatatables-wpdatatables-gutenberg-block\">\n<div class=\"wpdt-c wdt-skin-light\">\n    \n<input type=\"hidden\" id=\"wdtNonceFrontendEdit_18\" name=\"wdtNonceFrontendEdit_18\" value=\"a63dea86c8\" \/><input type=\"hidden\" name=\"_wp_http_referer\" value=\"\/de\/wp-json\/wp\/v2\/posts\/330\" \/>    <input type=\"hidden\" id=\"table_1_desc\"\n           value='{\"tableId\":\"table_1\",\"tableType\":\"manual\",\"selector\":\"#table_1\",\"responsive\":false,\"responsiveAction\":\"icon\",\"editable\":false,\"inlineEditing\":false,\"infoBlock\":true,\"pagination\":1,\"paginationAlign\":\"right\",\"paginationLayout\":\"full_numbers\",\"paginationLayoutMobile\":\"simple\",\"file_location\":\"\",\"tableSkin\":\"light\",\"scrollable\":false,\"globalSearch\":false,\"showRowsPerPage\":false,\"popoverTools\":false,\"hideBeforeLoad\":false,\"number_format\":1,\"decimalPlaces\":2,\"spinnerSrc\":\"https:\\\/\\\/www.bjorn-meijer.nl\\\/wp-content\\\/plugins\\\/wpdatatables\\\/assets\\\/\\\/img\\\/spinner.gif\",\"groupingEnabled\":false,\"tableWpId\":18,\"dataTableParams\":{\"sDom\":\"BT\\u003C\\u0027clear\\u0027\\u003Etip\",\"bSortCellsTop\":false,\"bFilter\":true,\"bPaginate\":true,\"sPaginationType\":\"full_numbers\",\"aLengthMenu\":[[1,5,10,25,50,100,-1],[1,5,10,25,50,100,\"Alle\"]],\"iDisplayLength\":10,\"columnDefs\":[{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"wdt_ID\",\"origHeader\":\"wdt_ID\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\"numdata integer  column-wdt_id\",\"aTargets\":[0]},{\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"datum\",\"origHeader\":\"datum\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\" column-datum\",\"aTargets\":[1]},{\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"getal\",\"origHeader\":\"getal\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\" column-getal\",\"aTargets\":[2]}],\"bAutoWidth\":false,\"order\":[[0,\"asc\"]],\"ordering\":false,\"fixedHeader\":{\"header\":false,\"headerOffset\":0},\"fixedColumns\":false,\"oLanguage\":{\"sProcessing\":\"Bezig...\",\"sLengthMenu\":\"_MENU_ resultaten weergeven\",\"sZeroRecords\":\"Geen resultaten gevonden\",\"sInfo\":\"_START_ tot _END_ van _TOTAL_ resultaten\",\"sInfoEmpty\":\"Geen resultaten om weer te geven\",\"sInfoFiltered\":\" (gefilterd uit _MAX_ resultaten)\",\"sInfoPostFix\":\"\",\"sSearch\":\"Zoeken:\",\"sSearchPlaceholder\":\"\",\"sEmptyTable\":\"Geen resultaten aanwezig in de tabel\",\"sInfoThousands\":\".\",\"sLoadingRecords\":\"Een moment geduld aub - bezig met laden...\",\"oPaginate\":{\"sFirst\":\"Eerste\",\"sLast\":\"Laatste\",\"sNext\":\"Volgende\",\"sPrevious\":\"Vorige\"}},\"buttons\":[],\"bProcessing\":false,\"serverSide\":true,\"ajax\":{\"url\":\"https:\\\/\\\/www.bjorn-meijer.nl\\\/wp-admin\\\/admin-ajax.php?action=get_wdtable&table_id=18\",\"type\":\"POST\"},\"oSearch\":{\"bSmart\":false,\"bRegex\":false,\"sSearch\":\"\"}},\"tabletWidth\":\"1024\",\"mobileWidth\":\"480\",\"renderFilter\":\"footer\",\"advancedFilterEnabled\":false,\"serverSide\":true,\"autoRefreshInterval\":0,\"processing\":true,\"fnServerData\":true,\"columnsFixed\":0,\"sumFunctionsLabel\":\"\",\"avgFunctionsLabel\":\"\",\"minFunctionsLabel\":\"\",\"maxFunctionsLabel\":\"\",\"columnsDecimalPlaces\":{\"wdt_ID\":-1,\"datum\":-1,\"getal\":-1},\"columnsThousandsSeparator\":{\"wdt_ID\":0},\"sumColumns\":[],\"avgColumns\":[],\"sumAvgColumns\":[],\"timeFormat\":\"H:i\",\"datepickFormat\":\"dd M yy\"}'\/>\n\n    <table id=\"table_1\"\n           class=\"display nowrap data-t data-t wpDataTable wpDataTableID-18\"\n           style=\"\"\n           data-described-by='table_1_desc'\n           data-wpdatatable_id=\"18\">\n        \n        <!-- Table header -->\n        \n<thead>\n<tr>\n                    <th\n                        class=\"wdtheader sort numdata integer\"\n        style=\"\">wdt_ID<\/th>        <th\n        data-class=\"expand\"                class=\"wdtheader sort\"\n        style=\"\">Datum<\/th>        <th\n                        class=\"wdtheader sort\"\n        style=\"\">Nummer<\/th>    <\/tr>\n<\/thead>\n        <!-- \/Table header -->\n\n        <!-- Table body -->\n        \n<tbody>\n            <tr id=\"table_18_row_0\">\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">1. Januar 1900<\/td>\n                            <td style=\"\">1<\/td>\n                    <\/tr>\n                <tr id=\"table_18_row_1\">\n                            <td style=\"\">2<\/td>\n                            <td style=\"\">15. Dezember 1995<\/td>\n                            <td style=\"\">35048<\/td>\n                    <\/tr>\n                <tr id=\"table_18_row_2\">\n                            <td style=\"\">3<\/td>\n                            <td style=\"\">24. Juni 2001<\/td>\n                            <td style=\"\">37066<\/td>\n                    <\/tr>\n                <tr id=\"table_18_row_3\">\n                            <td style=\"\">4<\/td>\n                            <td style=\"\">13. Juli 2003 15:00 Uhr<\/td>\n                            <td style=\"\">37832,63<\/td>\n                    <\/tr>\n    <\/tbody>        <!-- \/Table body -->\n\n        <!-- Table footer -->\n        \n        <!-- \/Table footer -->\n    <\/table>\n\n<\/div><style>\ntable.wpDataTable td.numdata { text-align: right !important; }\n<\/style>\n<style>\n<\/style>\n<\/div>\n\n\n\n<p>In der letzten Zeile der obigen Tabelle sehen Sie, dass dem Datum eine Uhrzeit hinzugef\u00fcgt wurde. Denn in Excel entspricht ein 24-Stunden-Tag 1, eine Stunde entspricht <img decoding=\"async\" src=\"https:\/\/s0.wp.com\/latex.php?latex=%5Cfrac%7B%5Ctext%7B1%7D%7D%7B%5Ctext%7B24%7D%7D+%3D0%2C042&#038;bg=ffffff&#038;fg=000&#038;s=0&#038;c=20201002\" alt=\"\\frac{\\text{1}}{\\text{24}} =0,042\" class=\"latex\" \/>. Zeit kann in Excel als Bruchwert von 1 dargestellt werden (siehe Tabelle unten). Um den Wert als Zeitformat nach einem Datum anzuzeigen, muss das Zeitformat in den Zelleneigenschaften hinzugef\u00fcgt werden.<\/p>\n\n\n\n<div class=\"wp-block-wpdatatables-wpdatatables-gutenberg-block\">\n<div class=\"wpdt-c wdt-skin-light\">\n    \n<input type=\"hidden\" id=\"wdtNonceFrontendEdit_19\" name=\"wdtNonceFrontendEdit_19\" value=\"d542f3b28a\" \/><input type=\"hidden\" name=\"_wp_http_referer\" value=\"\/de\/wp-json\/wp\/v2\/posts\/330\" \/>    <input type=\"hidden\" id=\"table_2_desc\"\n           value='{\"tableId\":\"table_2\",\"tableType\":\"manual\",\"selector\":\"#table_2\",\"responsive\":false,\"responsiveAction\":\"icon\",\"editable\":false,\"inlineEditing\":false,\"infoBlock\":true,\"pagination\":1,\"paginationAlign\":\"right\",\"paginationLayout\":\"full_numbers\",\"paginationLayoutMobile\":\"simple\",\"file_location\":\"\",\"tableSkin\":\"light\",\"scrollable\":false,\"globalSearch\":false,\"showRowsPerPage\":false,\"popoverTools\":false,\"hideBeforeLoad\":false,\"number_format\":1,\"decimalPlaces\":2,\"spinnerSrc\":\"https:\\\/\\\/www.bjorn-meijer.nl\\\/wp-content\\\/plugins\\\/wpdatatables\\\/assets\\\/\\\/img\\\/spinner.gif\",\"groupingEnabled\":false,\"tableWpId\":19,\"dataTableParams\":{\"sDom\":\"BT\\u003C\\u0027clear\\u0027\\u003Etip\",\"bSortCellsTop\":false,\"bFilter\":true,\"bPaginate\":true,\"sPaginationType\":\"full_numbers\",\"aLengthMenu\":[[1,5,10,25,50,100,-1],[1,5,10,25,50,100,\"Alle\"]],\"iDisplayLength\":-1,\"columnDefs\":[{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"wdt_ID\",\"origHeader\":\"wdt_ID\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\"numdata integer  column-wdt_id\",\"aTargets\":[0]},{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"uren\",\"origHeader\":\"uren\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\"numdata integer  column-uren\",\"aTargets\":[1]},{\"sType\":\"time-custom\",\"wdtType\":\"time\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"time\",\"name\":\"tijd\",\"origHeader\":\"tijd\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\" column-tijd\",\"aTargets\":[2]},{\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"breuk\",\"origHeader\":\"breuk\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\" column-breuk\",\"aTargets\":[3]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"waarde\",\"origHeader\":\"waarde\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\"numdata float  column-waarde\",\"aTargets\":[4]}],\"bAutoWidth\":false,\"order\":[[0,\"asc\"]],\"ordering\":false,\"fixedHeader\":{\"header\":false,\"headerOffset\":0},\"fixedColumns\":false,\"oLanguage\":{\"sProcessing\":\"Bezig...\",\"sLengthMenu\":\"_MENU_ resultaten weergeven\",\"sZeroRecords\":\"Geen resultaten gevonden\",\"sInfo\":\"_START_ tot _END_ van _TOTAL_ resultaten\",\"sInfoEmpty\":\"Geen resultaten om weer te geven\",\"sInfoFiltered\":\" (gefilterd uit _MAX_ resultaten)\",\"sInfoPostFix\":\"\",\"sSearch\":\"Zoeken:\",\"sSearchPlaceholder\":\"\",\"sEmptyTable\":\"Geen resultaten aanwezig in de tabel\",\"sInfoThousands\":\".\",\"sLoadingRecords\":\"Een moment geduld aub - bezig met laden...\",\"oPaginate\":{\"sFirst\":\"Eerste\",\"sLast\":\"Laatste\",\"sNext\":\"Volgende\",\"sPrevious\":\"Vorige\"}},\"buttons\":[],\"bProcessing\":false,\"serverSide\":true,\"ajax\":{\"url\":\"https:\\\/\\\/www.bjorn-meijer.nl\\\/wp-admin\\\/admin-ajax.php?action=get_wdtable&table_id=19\",\"type\":\"POST\"},\"oSearch\":{\"bSmart\":false,\"bRegex\":false,\"sSearch\":\"\"}},\"tabletWidth\":\"1024\",\"mobileWidth\":\"480\",\"renderFilter\":\"footer\",\"advancedFilterEnabled\":false,\"serverSide\":true,\"autoRefreshInterval\":0,\"processing\":true,\"fnServerData\":true,\"columnsFixed\":0,\"sumFunctionsLabel\":\"\",\"avgFunctionsLabel\":\"\",\"minFunctionsLabel\":\"\",\"maxFunctionsLabel\":\"\",\"columnsDecimalPlaces\":{\"wdt_ID\":-1,\"uren\":-1,\"tijd\":-1,\"breuk\":-1,\"waarde\":3},\"columnsThousandsSeparator\":{\"wdt_ID\":0,\"uren\":1},\"sumColumns\":[],\"avgColumns\":[],\"sumAvgColumns\":[],\"timeFormat\":\"H:i\",\"datepickFormat\":\"dd M yy\"}'\/>\n\n    <table id=\"table_2\"\n           class=\"display nowrap data-t data-t wpDataTable wpDataTableID-19\"\n           style=\"\"\n           data-described-by='table_2_desc'\n           data-wpdatatable_id=\"19\">\n        \n        <!-- Table header -->\n        \n<thead>\n<tr>\n                    <th\n                        class=\"wdtheader sort numdata integer\"\n        style=\"\">wdt_ID<\/th>        <th\n        data-class=\"expand\"                class=\"wdtheader sort numdata integer\"\n        style=\"\">Std<\/th>        <th\n                        class=\"wdtheader sort\"\n        style=\"\">Zeit<\/th>        <th\n                        class=\"wdtheader sort\"\n        style=\"\">Fraktur<\/th>        <th\n                        class=\"wdtheader sort numdata float\"\n        style=\"\">Bei dem die<\/th>    <\/tr>\n<\/thead>\n        <!-- \/Table header -->\n\n        <!-- Table body -->\n        \n<tbody>\n            <tr id=\"table_19_row_0\">\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">01:00<\/td>\n                            <td style=\"\">1\/24<\/td>\n                            <td style=\"\">0,042<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_1\">\n                            <td style=\"\">2<\/td>\n                            <td style=\"\">2<\/td>\n                            <td style=\"\">02:00<\/td>\n                            <td style=\"\">2\/24<\/td>\n                            <td style=\"\">0,083<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_2\">\n                            <td style=\"\">3<\/td>\n                            <td style=\"\">3<\/td>\n                            <td style=\"\">03:00<\/td>\n                            <td style=\"\">3\/24<\/td>\n                            <td style=\"\">0,125<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_3\">\n                            <td style=\"\">4<\/td>\n                            <td style=\"\">4<\/td>\n                            <td style=\"\">04:00<\/td>\n                            <td style=\"\">4\/24<\/td>\n                            <td style=\"\">0,167<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_4\">\n                            <td style=\"\">5<\/td>\n                            <td style=\"\">5<\/td>\n                            <td style=\"\">05:00<\/td>\n                            <td style=\"\">5\/24<\/td>\n                            <td style=\"\">0,208<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_5\">\n                            <td style=\"\">6<\/td>\n                            <td style=\"\">6<\/td>\n                            <td style=\"\">06:00<\/td>\n                            <td style=\"\">6\/24<\/td>\n                            <td style=\"\">0,250<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_6\">\n                            <td style=\"\">7<\/td>\n                            <td style=\"\">7<\/td>\n                            <td style=\"\">07:00<\/td>\n                            <td style=\"\">7\/24<\/td>\n                            <td style=\"\">0,292<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_7\">\n                            <td style=\"\">8<\/td>\n                            <td style=\"\">8<\/td>\n                            <td style=\"\">08:00<\/td>\n                            <td style=\"\">8\/24<\/td>\n                            <td style=\"\">0,333<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_8\">\n                            <td style=\"\">9<\/td>\n                            <td style=\"\">9<\/td>\n                            <td style=\"\">09:00<\/td>\n                            <td style=\"\">9\/24<\/td>\n                            <td style=\"\">0,375<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_9\">\n                            <td style=\"\">10<\/td>\n                            <td style=\"\">10<\/td>\n                            <td style=\"\">10:00<\/td>\n                            <td style=\"\">10\/24<\/td>\n                            <td style=\"\">0,417<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_10\">\n                            <td style=\"\">11<\/td>\n                            <td style=\"\">11<\/td>\n                            <td style=\"\">11:00<\/td>\n                            <td style=\"\">11\/24<\/td>\n                            <td style=\"\">0,458<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_11\">\n                            <td style=\"\">12<\/td>\n                            <td style=\"\">12<\/td>\n                            <td style=\"\">12:00<\/td>\n                            <td style=\"\">12\/24<\/td>\n                            <td style=\"\">0,500<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_12\">\n                            <td style=\"\">13<\/td>\n                            <td style=\"\">13<\/td>\n                            <td style=\"\">13:00<\/td>\n                            <td style=\"\">13\/24<\/td>\n                            <td style=\"\">0,542<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_13\">\n                            <td style=\"\">14<\/td>\n                            <td style=\"\">14<\/td>\n                            <td style=\"\">14:00<\/td>\n                            <td style=\"\">14\/24<\/td>\n                            <td style=\"\">0,583<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_14\">\n                            <td style=\"\">15<\/td>\n                            <td style=\"\">15<\/td>\n                            <td style=\"\">15:00<\/td>\n                            <td style=\"\">15\/24<\/td>\n                            <td style=\"\">0,625<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_15\">\n                            <td style=\"\">16<\/td>\n                            <td style=\"\">16<\/td>\n                            <td style=\"\">16:00<\/td>\n                            <td style=\"\">16\/24<\/td>\n                            <td style=\"\">0,667<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_16\">\n                            <td style=\"\">17<\/td>\n                            <td style=\"\">17<\/td>\n                            <td style=\"\">17:00<\/td>\n                            <td style=\"\">17\/24<\/td>\n                            <td style=\"\">0,708<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_17\">\n                            <td style=\"\">18<\/td>\n                            <td style=\"\">18<\/td>\n                            <td style=\"\">18:00<\/td>\n                            <td style=\"\">18\/24<\/td>\n                            <td style=\"\">0,750<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_18\">\n                            <td style=\"\">19<\/td>\n                            <td style=\"\">19<\/td>\n                            <td style=\"\">19:00<\/td>\n                            <td style=\"\">19\/24<\/td>\n                            <td style=\"\">0,792<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_19\">\n                            <td style=\"\">20<\/td>\n                            <td style=\"\">20<\/td>\n                            <td style=\"\">20:00<\/td>\n                            <td style=\"\">20\/24<\/td>\n                            <td style=\"\">0,833<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_20\">\n                            <td style=\"\">21<\/td>\n                            <td style=\"\">21<\/td>\n                            <td style=\"\">21:00<\/td>\n                            <td style=\"\">21\/24<\/td>\n                            <td style=\"\">0,875<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_21\">\n                            <td style=\"\">22<\/td>\n                            <td style=\"\">22<\/td>\n                            <td style=\"\">22:00<\/td>\n                            <td style=\"\">22\/24<\/td>\n                            <td style=\"\">0,917<\/td>\n                    <\/tr>\n                <tr id=\"table_19_row_22\">\n                            <td style=\"\">23<\/td>\n                            <td style=\"\">23<\/td>\n                            <td style=\"\">23:00<\/td>\n                            <td style=\"\">23\/24<\/td>\n                            <td style=\"\">0,958<\/td>\n                    <\/tr>\n    <\/tbody>        <!-- \/Table body -->\n\n        <!-- Table footer -->\n        \n        <!-- \/Table footer -->\n    <\/table>\n\n<\/div><style>\ntable.wpDataTable td.numdata { text-align: right !important; }\n<\/style>\n<style>\n<\/style>\n<style>\n                            \n                        \/* rows hover background color *\/\n    .wpdt-c.wpDataTablesWrapper table#wpdtSimpleTable-19 tr.odd:hover > td,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable.wpDataTableID-19 tr.odd:hover > td,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable.wpDataTableID-19 tr.odd:hover > td.sorting_1,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable.wpDataTableID-19 tr.even:hover > td,\n    .wpdt-c.wpDataTablesWrapper table#wpdtSimpleTable-19 tr.even:hover > td,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable.wpDataTableID-19 tr.even:hover > td.sorting_1 {\n        background-color: #FFFFFF !important;\n    }\n                        \n                <\/style>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-van-unix-tijdstempel-naar-excel-datum\">Vom Unix-Zeitstempel zum Excel-Datum<\/h2>\n\n\n\n<p>Ein Unix-Zeitstempel ist wie <a href=\"#h-wat-is-een-unix-tijdstempel\">hier oben<\/a> beschreibt die Anzahl der Sekunden, die seit dem 1. Januar 1970 vergangen sind. Ein ganzer Tag besteht also aus <img decoding=\"async\" src=\"https:\/\/s0.wp.com\/latex.php?latex=60%2A60%2A24%3D86.400&#038;bg=ffffff&#038;fg=000&#038;s=0&#038;c=20201002\" alt=\"60*60*24=86.400\" class=\"latex\" \/> Sekunden (60 Sekunden x 60 Minuten x 24 Stunden). Teilen wir den Unix-Zeitstempel durch 86.400, haben wir die Anzahl der Tage ab dem 1. Januar 1970. Addieren wir den Datumswert vom 1. Januar 1970 (in Excel ist das die Zahl 25.569), haben wir das Excel-Datum. Wir k\u00f6nnen dies mit der Formel tun:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=A2\/86400+DATUM(1970;1;1)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"319\" height=\"161\" src=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum.jpg\" alt=\"Unix-Zeitstempel zum Excel-Datum\" class=\"wp-image-347\" srcset=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum.jpg 319w, https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum-300x151.jpg 300w, https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum-18x9.jpg 18w\" sizes=\"(max-width: 319px) 100vw, 319px\" \/><figcaption>Unix-Zeitstempel zum Excel-Datum<\/figcaption><\/figure>","protected":false},"excerpt":{"rendered":"<p>Was ist ein Unix-Zeitstempel? Ein Unix-Zeitstempel ist die Anzahl der Sekunden, die seit Mitternacht des 1. Januar 1970 vergangen sind. Hier sind\u2026 <a class=\"read-more\" href=\"https:\/\/www.bjorn-meijer.nl\/de\/2021\/10\/19\/konvertiere-unix-zeitstempel-in-excel-datum\/\">Weiterlesen<\/a><\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7],"tags":[17],"class_list":["post-330","post","type-post","status-publish","format-standard","hentry","category-excel","tag-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.11 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Converteer Unix-tijdstempel naar Excel-datum - Bj\u00f6rn Meijer<\/title>\n<meta name=\"description\" content=\"Een Unix-tijdstempel is het aantal seconden dat is verstreken sinds 1 januari 1970 middernacht. Hierbij zijn de schrikkelseconden niet meegerekend.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bjorn-meijer.nl\/de\/2021\/10\/19\/konvertiere-unix-zeitstempel-in-excel-datum\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Converteer Unix-tijdstempel naar Excel-datum\" \/>\n<meta property=\"og:description\" content=\"Wat is een Unix-tijdstempel? Een Unix-tijdstempel is het aantal seconden dat is verstreken sinds 1 januari 1970 middernacht. Hierbij zijn de\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bjorn-meijer.nl\/de\/2021\/10\/19\/konvertiere-unix-zeitstempel-in-excel-datum\/\" \/>\n<meta property=\"og:site_name\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-19T19:37:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-02T20:39:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum.jpg\" \/>\n<meta name=\"author\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bj\u00f6rn Meijer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/\"},\"author\":{\"name\":\"Bj\u00f6rn Meijer\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"headline\":\"Converteer Unix-tijdstempel naar Excel-datum\",\"datePublished\":\"2021-10-19T19:37:00+00:00\",\"dateModified\":\"2021-11-02T20:39:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/\"},\"wordCount\":265,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum.jpg\",\"keywords\":[\"excel\"],\"articleSection\":[\"Excel\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/\",\"name\":\"Converteer Unix-tijdstempel naar Excel-datum - Bj\u00f6rn Meijer\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum.jpg\",\"datePublished\":\"2021-10-19T19:37:00+00:00\",\"dateModified\":\"2021-11-02T20:39:21+00:00\",\"description\":\"Een Unix-tijdstempel is het aantal seconden dat is verstreken sinds 1 januari 1970 middernacht. Hierbij zijn de schrikkelseconden niet meegerekend.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#primaryimage\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum.jpg\",\"contentUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.bjorn-meijer.nl\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Converteer Unix-tijdstempel naar Excel-datum\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/de\/\",\"name\":\"Bj\u00f6rn Meijer\",\"description\":\"At My Playground\",\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\",\"name\":\"Bj\u00f6rn Meijer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"width\":165,\"height\":165,\"caption\":\"Bj\u00f6rn Meijer\"},\"logo\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.bjorn-meijer.nl\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Converteer Unix-tijdstempel naar Excel-datum - Bj\u00f6rn Meijer","description":"Een Unix-tijdstempel is het aantal seconden dat is verstreken sinds 1 januari 1970 middernacht. Hierbij zijn de schrikkelseconden niet meegerekend.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.bjorn-meijer.nl\/de\/2021\/10\/19\/konvertiere-unix-zeitstempel-in-excel-datum\/","og_locale":"de_DE","og_type":"article","og_title":"Converteer Unix-tijdstempel naar Excel-datum","og_description":"Wat is een Unix-tijdstempel? Een Unix-tijdstempel is het aantal seconden dat is verstreken sinds 1 januari 1970 middernacht. Hierbij zijn de","og_url":"https:\/\/www.bjorn-meijer.nl\/de\/2021\/10\/19\/konvertiere-unix-zeitstempel-in-excel-datum\/","og_site_name":"Bj\u00f6rn Meijer","article_published_time":"2021-10-19T19:37:00+00:00","article_modified_time":"2021-11-02T20:39:21+00:00","og_image":[{"url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum.jpg"}],"author":"Bj\u00f6rn Meijer","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"Bj\u00f6rn Meijer","Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#article","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/"},"author":{"name":"Bj\u00f6rn Meijer","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"headline":"Converteer Unix-tijdstempel naar Excel-datum","datePublished":"2021-10-19T19:37:00+00:00","dateModified":"2021-11-02T20:39:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/"},"wordCount":265,"commentCount":0,"publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum.jpg","keywords":["excel"],"articleSection":["Excel"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/","url":"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/","name":"Converteer Unix-tijdstempel naar Excel-datum - Bj\u00f6rn Meijer","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#primaryimage"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum.jpg","datePublished":"2021-10-19T19:37:00+00:00","dateModified":"2021-11-02T20:39:21+00:00","description":"Een Unix-tijdstempel is het aantal seconden dat is verstreken sinds 1 januari 1970 middernacht. Hierbij zijn de schrikkelseconden niet meegerekend.","breadcrumb":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#primaryimage","url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum.jpg","contentUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/10\/Excel-Unix-tijdstempel-naar-Excel-datum.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.bjorn-meijer.nl\/2021\/10\/19\/converteer-unix-tijdstempel-naar-excel-datum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bjorn-meijer.nl\/de\/"},{"@type":"ListItem","position":2,"name":"Converteer Unix-tijdstempel naar Excel-datum"}]},{"@type":"WebSite","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website","url":"https:\/\/www.bjorn-meijer.nl\/de\/","name":"Bj\u00f6rn Meijer","description":"At My Playground","publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615","name":"Bj\u00f6rn Meijer","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","width":165,"height":165,"caption":"Bj\u00f6rn Meijer"},"logo":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.bjorn-meijer.nl"]}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/posts\/330","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/comments?post=330"}],"version-history":[{"count":16,"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/posts\/330\/revisions"}],"predecessor-version":[{"id":348,"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/posts\/330\/revisions\/348"}],"wp:attachment":[{"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/media?parent=330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/categories?post=330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/tags?post=330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}