Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=137
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=138", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=136", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=ZÄHLENWENNS(A2:A6;\".*stift\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": -849600324358677609, "content_hash": -849600324358677609, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id267603146513224\nhelp.text", "note": "jdWB5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6801, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111156081/?format=api", "priority": 100, "id": 112009309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=74359d01a18b5b97", "url": "https://translations.documentfoundation.org/api/units/112009309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.688747Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Counts the amount of rows that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range with exception of its maximum. Returns 1, because only second row meets all criteria." ], "previous_source": "", "target": [ "Zählt die Anzahl der Zeilen, deren Zellen im Bereich A2:A6 auf \"stift\" enden und deren Zellen im Bereich B2:B6 nicht den Maximalwert enthalten. Ergibt 1, da nur die zweite Zeile alle Bedingungen erfüllt." ], "id_hash": -1581394730398256572, "content_hash": -1581394730398256572, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id111252614832220\nhelp.text", "note": "L6af2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6802, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/111156126/?format=api", "priority": 100, "id": 112009312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=6a0dc1df0ceff244", "url": "https://translations.documentfoundation.org/api/units/112009312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.690534Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Bezüge zu einer Zelle mit einer Bedingung" ], "id_hash": -8660103929084940670, "content_hash": -8660103929084940670, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nhd_id212582362610399\nhelp.text", "note": "rG36d", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6803, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111156168/?format=api", "priority": 100, "id": 112009315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=07d1215c14ed6e82", "url": "https://translations.documentfoundation.org/api/units/112009315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.692087Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the COUNTIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "Um eine Bedingung einfach zu ändern, bietet es sich an, diese in einer separaten Zelle festzulegen und für die Bedingung der Funktion ZÄHLENWENNS einen Bezug zur Zelle anzugeben. Beispielsweise kann obige Funktion geschrieben werden als:" ], "id_hash": -3306896990901796710, "content_hash": -3306896990901796710, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id3245551524846\nhelp.text", "note": "ABwGC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6804, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111156211/?format=api", "priority": 100, "id": 112009318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=521b8ab51c7d809a", "url": "https://translations.documentfoundation.org/api/units/112009318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.693235Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=ZÄHLENWENNS(A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 5460089609370278782, "content_hash": 5460089609370278782, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id109501907712434\nhelp.text", "note": "3TTwe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6805, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111156262/?format=api", "priority": 100, "id": 112009321, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=cbc6229228511b7e", "url": "https://translations.documentfoundation.org/api/units/112009321/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.694704Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above." ], "previous_source": "", "target": [ "Wenn E2 = stift ist, ergibt die Funktion 1, da der Bezug zur Zelle derem Inhalt entspricht und wie die Funktion oben funktioniert." ], "id_hash": 750788171635273601, "content_hash": 750788171635273601, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id738533068520\nhelp.text", "note": "CNQBL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6806, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111156312/?format=api", "priority": 100, "id": 112009326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=8a6b55dd3fe2af81", "url": "https://translations.documentfoundation.org/api/units/112009326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.697750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/COUNTIFS\">COUNTIFS wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/COUNTIFS\">Wikiseite zu ZÄHLENWENNS</link>." ], "id_hash": -5480921083094322148, "content_hash": -5480921083094322148, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id131677016670241\nhelp.text", "note": "UXGKC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6807, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111156367/?format=api", "priority": 100, "id": 112009330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=33efdb506836b41c", "url": "https://translations.documentfoundation.org/api/units/112009330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.700391Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "DATE" ], "previous_source": "", "target": [ "DATUM" ], "id_hash": 2251092497364006255, "content_hash": 2251092497364006255, "location": "func_date.xhp", "context": "func_date.xhp\ntit\nhelp.text", "note": "GW3GV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6808, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111156415/?format=api", "priority": 100, "id": 112009335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9f3d7cb315edb56f", "url": "https://translations.documentfoundation.org/api/units/112009335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.703780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>DATE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DATUM (Funktion)</bookmark_value>" ], "id_hash": -8529043966727092037, "content_hash": -8529043966727092037, "location": "func_date.xhp", "context": "func_date.xhp\nbm_id3155511\nhelp.text", "note": "xCZGR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6809, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111156442/?format=api", "priority": 100, "id": 112009338, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=09a2bfb3798b08bb", "url": "https://translations.documentfoundation.org/api/units/112009338/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.706760Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"date\"><link href=\"text/scalc/01/func_date.xhp\">DATE</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"date\"><link href=\"text/scalc/01/func_date.xhp\">DATUM</link></variable>" ], "id_hash": 1935387799744484713, "content_hash": 1935387799744484713, "location": "func_date.xhp", "context": "func_date.xhp\nhd_id3155511\nhelp.text", "note": "TioqL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6810, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111156468/?format=api", "priority": 100, "id": 112009341, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9adbe0f322651569", "url": "https://translations.documentfoundation.org/api/units/112009341/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.708766Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DATUM\">This function calculates a date specified by year, month, day and displays it in the cell's formatting.</ahelp> The default format of a cell containing the DATE function is the date format, but you can format the cells with any other number format." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DATUM\">Diese Funktion konvertiert ein in der Form Jahr, Monat, Tag eingegebenes Datum in eine interne Seriennummer und zeigt sie im Format der Zelle an.</ahelp> Das Standardformat für Zellen mit der Funktion DATUM ist das Datumsformat, Sie können die Zellen jedoch in jedem anderen Zahlenformat formatieren." ], "id_hash": -3191741950403674441, "content_hash": -3191741950403674441, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3153551\nhelp.text", "note": "Wa2yU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6811, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/111156510/?format=api", "priority": 100, "id": 112009344, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=53b4a79b4f79feb7", "url": "https://translations.documentfoundation.org/api/units/112009344/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.710517Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "DATE(Year; Month; Day)" ], "previous_source": "", "target": [ "DATUM(Jahr; Monat; Tag)" ], "id_hash": -368305019053121377, "content_hash": -368305019053121377, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3150474\nhelp.text", "note": "wCGHA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6812, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111156560/?format=api", "priority": 100, "id": 112009349, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7ae384895a58609f", "url": "https://translations.documentfoundation.org/api/units/112009349/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.712285Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Year</emph> is an integer between 1583 and 9957 or between 0 and 99." ], "previous_source": "", "target": [ "<emph>Jahr</emph> ist eine ganze Zahl zwischen 1583 und 9957 oder 0 und 99." ], "id_hash": -2694903448988203180, "content_hash": -2694903448988203180, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3152815\nhelp.text", "note": "zExSG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6813, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/111156631/?format=api", "priority": 100, "id": 112009350, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=5a99c79763154754", "url": "https://translations.documentfoundation.org/api/units/112009350/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.713726Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "In <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><item type=\"menuitem\"> - $[officename] - General </item>you can set from which year a two-digit number entry is recognized as 20xx." ], "previous_source": "", "target": [ "Wählen Sie <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME – Einstellungen</item></caseinline><defaultinline><item type=\"menuitem\">Extras – Optionen…</item></defaultinline></switchinline><item type=\"menuitem\"> – $[officename] – Allgemein</item>, um festzulegen, für welche Jahre eine zweistellige Zahl als 20xx erkannt wird." ], "id_hash": -4638706367466650632, "content_hash": -4638706367466650632, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3153222\nhelp.text", "note": "WVjaD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6814, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111156684/?format=api", "priority": 100, "id": 112009357, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3fa00122bdcec3f8", "url": "https://translations.documentfoundation.org/api/units/112009357/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.718016Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Month</emph> is an integer indicating the month." ], "previous_source": "", "target": [ "<emph>Monat</emph> ist eine Zahl zwischen 1 und 12, durch welche die Monatszahl angegeben wird." ], "id_hash": 7683876209887228883, "content_hash": 7683876209887228883, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3155817\nhelp.text", "note": "uuZQH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6815, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111156727/?format=api", "priority": 100, "id": 112009364, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=eaa29cb3b46733d3", "url": "https://translations.documentfoundation.org/api/units/112009364/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.723163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Day</emph> is an integer indicating the day of the month." ], "previous_source": "", "target": [ "<emph>Tag</emph> ist eine Zahl zwischen 1 und 31, die den Tag des Monats festlegt." ], "id_hash": -8693193480117539245, "content_hash": -8693193480117539245, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3153183\nhelp.text", "note": "gKdnj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6816, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111156799/?format=api", "priority": 100, "id": 112009376, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=075b92969dda2e53", "url": "https://translations.documentfoundation.org/api/units/112009376/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.736317Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "If the values for month and day are out of bounds, they are carried over to the next digit. If you enter <item type=\"input\">=DATE(00;12;31)</item> the result will be 2000-12-31. If, on the other hand, you enter <item type=\"input\">=DATE(00;13;31)</item> the result will be 2001-01-31." ], "previous_source": "", "target": [ "Wenn die Werte für Monat und Tag außerhalb der Grenzbereiche liegen, werden sie auf die nächste Stelle übertragen. Wenn Sie <item type=\"input\">=DATUM(00;12;31)</item> eingeben, wird als Ergebnis 31.12.00 angezeigt. Wenn Sie aber <item type=\"input\">=DATUM(00;13;31)</item> eingeben, wird als Ergebnis 31.01.01 angezeigt." ], "id_hash": -2805345022247207274, "content_hash": -2805345022247207274, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3156260\nhelp.text", "note": "qr3Qv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6817, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/111156831/?format=api", "priority": 100, "id": 112009380, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=59116990cc8b7e96", "url": "https://translations.documentfoundation.org/api/units/112009380/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.739464Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=DATE(00;1;31)</item> yields 1/31/00 if the cell format setting is MM/DD/YY." ], "previous_source": "", "target": [ "<item type=\"input\">=DATUM(00;1;31)</item> gibt 1/31/00 zurück, wenn das Zellformat MM/TT/JJ eingestellt ist." ], "id_hash": 4749350668886780999, "content_hash": 4749350668886780999, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3152589\nhelp.text", "note": "8E7EB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6818, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111156861/?format=api", "priority": 100, "id": 112009385, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=c1e915452cc2ac47", "url": "https://translations.documentfoundation.org/api/units/112009385/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.742555Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATE\">DATE wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATE/de\">Wikiseite zu DATUM</link>." ], "id_hash": 9142693871924327261, "content_hash": 9142693871924327261, "location": "func_date.xhp", "context": "func_date.xhp\npar_id701677016652715\nhelp.text", "note": "E6eJP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6819, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111156895/?format=api", "priority": 100, "id": 112009390, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=fee15fa2ee30b35d", "url": "https://translations.documentfoundation.org/api/units/112009390/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.747801Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "DATEDIF" ], "previous_source": "", "target": [ "DATUMDIF" ], "id_hash": 6740804122783923502, "content_hash": 6740804122783923502, "location": "func_datedif.xhp", "context": "func_datedif.xhp\ntit\nhelp.text", "note": "pCLUK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6820, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111156920/?format=api", "priority": 100, "id": 112009394, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=dd8c25a2a7063d2e", "url": "https://translations.documentfoundation.org/api/units/112009394/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.750514Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>DATEDIF function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DATUMDIF (Funktion)</bookmark_value>" ], "id_hash": 6884072082915960064, "content_hash": 6884072082915960064, "location": "func_datedif.xhp", "context": "func_datedif.xhp\nbm_id3155511\nhelp.text", "note": "kaPiN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6821, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111156992/?format=api", "priority": 100, "id": 112009396, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=df8923160663a500", "url": "https://translations.documentfoundation.org/api/units/112009396/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.752090Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"datedif\"><link href=\"text/scalc/01/func_datedif.xhp\">DATEDIF</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"datedif\"><link href=\"text/scalc/01/func_datedif.xhp\">DATUMDIF</link></variable>" ], "id_hash": 3482088900642389725, "content_hash": 3482088900642389725, "location": "func_datedif.xhp", "context": "func_datedif.xhp\nhd_id3155511\nhelp.text", "note": "M9yvp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6822, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111157061/?format=api", "priority": 100, "id": 112009400, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=b052dd67ff1ebedd", "url": "https://translations.documentfoundation.org/api/units/112009400/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.753985Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DATEDIF\">This function returns the number of whole days, months or years between Start date and End date.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DATEDIF\">Diese Funktion ergibt die Anzahl der Tage, Monate oder Jahre zwischen Startdatum und Enddatum.</ahelp>" ], "id_hash": -2371494047288475160, "content_hash": -2371494047288475160, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3153551\nhelp.text", "note": "mf9mw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6823, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111157100/?format=api", "priority": 100, "id": 112009404, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=5f16c2ba8c6ac1e8", "url": "https://translations.documentfoundation.org/api/units/112009404/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.756026Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>DATEDIF(Start date; End date; Interval)</input>" ], "previous_source": "", "target": [ "<input>DATUMDIF(Anfangsdatum; Enddatum; Intervall)</input>" ], "id_hash": -3427516773167903269, "content_hash": -3427516773167903269, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id531642776283977\nhelp.text", "note": "zRWUX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6824, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111157126/?format=api", "priority": 100, "id": 112009410, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=506f03a791a24ddb", "url": "https://translations.documentfoundation.org/api/units/112009410/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.759340Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Start date</emph> is the date from when the calculation is carried out." ], "previous_source": "", "target": [ "<emph>Anfangsdatum</emph> ist das Datum, von dem die Berechnung startet." ], "id_hash": -2102018359482776008, "content_hash": -2102018359482776008, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3152815\nhelp.text", "note": "CMjse", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6825, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/111157154/?format=api", "priority": 100, "id": 112009415, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=62d4217063ae0638", "url": "https://translations.documentfoundation.org/api/units/112009415/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.761471Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>End date</emph> is the date until the calculation is carried out. End date must be later, than Start date." ], "previous_source": "", "target": [ "<emph>Enddatum</emph> ist das Datum, bis zu dem die Berechnung geht. Enddatum muss später als Anfangsdatum liegen, ansonsten gibt die Funktion einen Fehlerwert zurück." ], "id_hash": 8787724946176264569, "content_hash": 8787724946176264569, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3155817\nhelp.text", "note": "HbrrC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6826, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111157218/?format=api", "priority": 100, "id": 112009422, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=f9f4454778acc979", "url": "https://translations.documentfoundation.org/api/units/112009422/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.765835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Interval</emph> is a string that determines how the difference will be calculated. Possible values are \"d\", \"m\", \"y\", \"ym\", \"md\" or \"yd\" regardless of the current language settings." ], "previous_source": "", "target": [ "<emph>Intervall</emph> ist eine Zeichenfolge, die bestimmt, wie die Differenz berechnet wird. Mögliche Werte sind \"d\", \"m\", \"y\", \"ym\", \"md\" oder \"yd\", unabhängig von den aktuellen Spracheinstellungen." ], "id_hash": -5433354282961397849, "content_hash": -5433354282961397849, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3153183\nhelp.text", "note": "PZGXK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6827, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/111157258/?format=api", "priority": 100, "id": 112009425, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3498d911193d17a7", "url": "https://translations.documentfoundation.org/api/units/112009425/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.768869Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Value for \"Interval\"" ], "previous_source": "", "target": [ "Wert für \"Intervall\"" ], "id_hash": -4311460284550309334, "content_hash": -4311460284550309334, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id5735953\nhelp.text", "note": "Lxgdp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6828, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111157288/?format=api", "priority": 100, "id": 112009433, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=442a9db6dc2c9a2a", "url": "https://translations.documentfoundation.org/api/units/112009433/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.779703Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Return value" ], "previous_source": "", "target": [ "Rückgabewert" ], "id_hash": 604943674501351481, "content_hash": 604943674501351481, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id8360850\nhelp.text", "note": "UBcKr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6829, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111157325/?format=api", "priority": 100, "id": 112009436, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=886531111bc5c839", "url": "https://translations.documentfoundation.org/api/units/112009436/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.781686Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Number of whole days between Start date and End date." ], "previous_source": "", "target": [ "Anzahl der Tage zwischen dem Start- und End-Datum." ], "id_hash": 7843862400438312367, "content_hash": 7843862400438312367, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id908841\nhelp.text", "note": "iTUCH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6830, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111157358/?format=api", "priority": 100, "id": 112009439, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=ecdaff4b6d2b1daf", "url": "https://translations.documentfoundation.org/api/units/112009439/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.783301Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Number of whole months between Start date and End date." ], "previous_source": "", "target": [ "Anzahl der Monate zwischen dem Start- und End-Datum." ], "id_hash": 6097456227596925363, "content_hash": 6097456227596925363, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id9841608\nhelp.text", "note": "KTzdL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6831, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111157365/?format=api", "priority": 100, "id": 112009443, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=d49e84221f6879b3", "url": "https://translations.documentfoundation.org/api/units/112009443/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.785531Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Number of whole years between Start date and End date." ], "previous_source": "", "target": [ "Anzahl der Jahre zwischen dem Start- und End-Datum." ], "id_hash": -4584622588397463497, "content_hash": -4584622588397463497, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id2136295\nhelp.text", "note": "jMGKG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6832, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111157411/?format=api", "priority": 100, "id": 112009446, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=4060260bd5565837", "url": "https://translations.documentfoundation.org/api/units/112009446/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.787482Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Number of whole months when subtracting years from the difference of Start date and End date." ], "previous_source": "", "target": [ "Anzahl der vollen Monate zwischen Start- und Enddatum abzüglich der vollen Jahre." ], "id_hash": -6880284385997826426, "content_hash": -6880284385997826426, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id4186223\nhelp.text", "note": "8tDzh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6833, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/111157466/?format=api", "priority": 100, "id": 112009450, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=208451cde2eed686", "url": "https://translations.documentfoundation.org/api/units/112009450/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.789051Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Number of whole days when subtracting years and months from the difference of Start date and End date." ], "previous_source": "", "target": [ "Anzahl der Tage zwischen Start- und Enddatum abzüglich der vollen Jahre und Monate." ], "id_hash": -5027714273302804362, "content_hash": -5027714273302804362, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id1491134\nhelp.text", "note": "jShMp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6834, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111157500/?format=api", "priority": 100, "id": 112009453, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3a39f881a3a00876", "url": "https://translations.documentfoundation.org/api/units/112009453/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.790928Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Number of whole days when subtracting years from the difference of Start date and End date." ], "previous_source": "", "target": [ "Anzahl der Tage zwischen Start- und Enddatum abzüglich der vollen Jahre." ], "id_hash": -3296450993913875283, "content_hash": -3296450993913875283, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id1591134\nhelp.text", "note": "9uGY2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6835, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/111157532/?format=api", "priority": 100, "id": 112009458, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=5240a7495047b4ad", "url": "https://translations.documentfoundation.org/api/units/112009458/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.792907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Birthday calculation. A man was born on 1974-04-17. Today is 2012-06-13." ], "previous_source": "", "target": [ "Berechnung des Alters: Geburtstag ist der 17.04.1974 und das heutige Datum ist der 13.06.2012." ], "id_hash": -6403980983078559052, "content_hash": -6403980983078559052, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3152589\nhelp.text", "note": "Pc57T", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6836, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111157584/?format=api", "priority": 100, "id": 112009461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=27207d39c33ee2b4", "url": "https://translations.documentfoundation.org/api/units/112009461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.794771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=DATEDIF(\"1974-04-17\";\"2012-06-13\";\"y\")</item> yields 38." ], "previous_source": "", "target": [ "<item type=\"input\">=DATUMDIF(\"1974-04-17\";\"2012-06-13\";\"y\")</item> ergibt 38." ], "id_hash": 1572784543502768095, "content_hash": 1572784543502768095, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3252589\nhelp.text", "note": "jbcJE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6837, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111157617/?format=api", "priority": 100, "id": 112009466, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=95d3a73597b517df", "url": "https://translations.documentfoundation.org/api/units/112009466/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.796812Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=DATEDIF(\"1974-04-17\";\"2012-06-13\";\"ym\")</item> yields 1." ], "previous_source": "", "target": [ "<item type=\"input\">=DATUMDIF(\"1974-04-17\";\"2012-06-13\";\"ym\")</item> ergibt 1." ], "id_hash": -8359619102651616060, "content_hash": -8359619102651616060, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id451535132395328\nhelp.text", "note": "k75FH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6838, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111157664/?format=api", "priority": 100, "id": 112009476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=0bfcaab7a0e174c4", "url": "https://translations.documentfoundation.org/api/units/112009476/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.802555Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=DATEDIF(\"1974-04-17\";\"2012-06-13\";\"md\")</item> yields 27." ], "previous_source": "", "target": [ "<item type=\"input\">=DATUMDIF(\"1974-04-17\";\"2012-06-13\";\"md\")</item> ergibt 27." ], "id_hash": 7939076543787167882, "content_hash": 7939076543787167882, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id611535132402642\nhelp.text", "note": "3dbKg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6839, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111157704/?format=api", "priority": 100, "id": 112009480, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=ee2d440db511f08a", "url": "https://translations.documentfoundation.org/api/units/112009480/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.805219Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "So he is 38 years, 1 month and 27 days old." ], "previous_source": "", "target": [ "Somit ist er 38 Jahre, 1 Monat und 27 Tage alt." ], "id_hash": -8494200851194337862, "content_hash": -8494200851194337862, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id511535132411940\nhelp.text", "note": "LA2Rw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6840, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111157735/?format=api", "priority": 100, "id": 112009483, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=0a1e89547dbda5ba", "url": "https://translations.documentfoundation.org/api/units/112009483/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.807930Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=DATEDIF(DATE(1974,4,17);\"2012-06-13\";\"m\")</item> yields 457, he has been living for 457 months." ], "previous_source": "", "target": [ "<item type=\"input\">=DATUMDIF(DATUM(1974,4,17);\"2012-06-13\";\"m\")</item> ergibt 457, er hat 457 Monate gelebt." ], "id_hash": -606512305123497102, "content_hash": -606512305123497102, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3352589\nhelp.text", "note": "yuWBU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6841, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111157751/?format=api", "priority": 100, "id": 112009487, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=77953c459d35eb72", "url": "https://translations.documentfoundation.org/api/units/112009487/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.810839Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=DATEDIF(\"1974-04-17\";\"2012-06-13\";\"d\")</item> yields 13937, he has been living for 13937 days." ], "previous_source": "", "target": [ "<item type=\"input\">=DATUMDIF(\"1974-04-17\";\"2012-06-13\";\"d\")</item> ergibt 13937 Tage." ], "id_hash": 6687338299348872003, "content_hash": 6687338299348872003, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3452589\nhelp.text", "note": "tFAxV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6842, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111157771/?format=api", "priority": 100, "id": 112009492, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=dcce32c0918deb43", "url": "https://translations.documentfoundation.org/api/units/112009492/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.814601Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=DATEDIF(\"1974-04-17\";DATE(2012;06;13);\"yd\")</item> yields 57, his birthday was 57 days ago." ], "previous_source": "", "target": [ "<item type=\"input\">=DATUMDIF(\"1974-04-17\";DATUM(2012;06;13);\"yd\")</item> ergibt 57, er hatte vor 57 Tagen Geburtstag." ], "id_hash": 4215226995317180321, "content_hash": 4215226995317180321, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3752589\nhelp.text", "note": "C8DrL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6843, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111157780/?format=api", "priority": 100, "id": 112009495, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=ba7f7e9e778487a1", "url": "https://translations.documentfoundation.org/api/units/112009495/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.817419Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATEDIF\">DATEDIF wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATEDIF/de\">Wikiseite zu DATUMDIF</link>." ], "id_hash": -7472999374401978605, "content_hash": -7472999374401978605, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id311677016639702\nhelp.text", "note": "WrGbq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6844, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111157801/?format=api", "priority": 100, "id": 112009498, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=184a92a9a20dbf13", "url": "https://translations.documentfoundation.org/api/units/112009498/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.819822Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "DATEVALUE" ], "previous_source": "", "target": [ "DATUMWERT" ], "id_hash": -3943816444800731105, "content_hash": -3943816444800731105, "location": "func_datevalue.xhp", "context": "func_datevalue.xhp\ntit\nhelp.text", "note": "7eFQV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6845, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111157821/?format=api", "priority": 100, "id": 112009502, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=4944bfd6b44ef81f", "url": "https://translations.documentfoundation.org/api/units/112009502/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.822490Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>DATEVALUE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DATUMWERT (Funktion)</bookmark_value>" ], "id_hash": -229758553696394200, "content_hash": -229758553696394200, "location": "func_datevalue.xhp", "context": "func_datevalue.xhp\nbm_id3145621\nhelp.text", "note": "s5yZC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6846, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111157850/?format=api", "priority": 100, "id": 112009504, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7ccfbbd00ed1a428", "url": "https://translations.documentfoundation.org/api/units/112009504/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.824206Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"datevalue\"><link href=\"text/scalc/01/func_datevalue.xhp\">DATEVALUE</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"datevalue\"><link href=\"text/scalc/01/func_datevalue.xhp\">DATUMWERT</link></variable>" ], "id_hash": -281370068708809570, "content_hash": -281370068708809570, "location": "func_datevalue.xhp", "context": "func_datevalue.xhp\nhd_id3145621\nhelp.text", "note": "e4YFG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6847, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111157876/?format=api", "priority": 100, "id": 112009510, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7c185f69cc2f249e", "url": "https://translations.documentfoundation.org/api/units/112009510/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.829481Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DATWERT\">Returns the internal date number for text in quotes.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DATWERT\">Ergibt die interne Datumszahl für Text in Anführungszeichen.</ahelp>" ], "id_hash": 7439343599221332917, "content_hash": 7439343599221332917, "location": "func_datevalue.xhp", "context": "func_datevalue.xhp\npar_id3145087\nhelp.text", "note": "kVQP6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6848, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111157908/?format=api", "priority": 100, "id": 112009513, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=e73ddb9691a9dbb5", "url": "https://translations.documentfoundation.org/api/units/112009513/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.831929Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "The internal date number is returned as a number. The number is determined by the date system that is used by $[officename] to calculate dates." ], "previous_source": "", "target": [ "Die interne Datumszahl wird als eine Zahl ausgegeben. Die Zahl wird vom Datumssystem bestimmt, dass von $[officename] zum Berechnen von Daten verwendet wird." ], "id_hash": 1446120959308434099, "content_hash": 1446120959308434099, "location": "func_datevalue.xhp", "context": "func_datevalue.xhp\npar_id3149281\nhelp.text", "note": "z3vTn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6849, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/111157944/?format=api", "priority": 100, "id": 112009520, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9411a759c1d38ab3", "url": "https://translations.documentfoundation.org/api/units/112009520/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.836495Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "If the text string also includes a time value, DATEVALUE only returns the integer part of the conversion." ], "previous_source": "", "target": [ "Wenn der Text zusätzlich einen Zeitwert enthält, ergibt DATUMWERT nur den ganzzahligen Anteil." ], "id_hash": 8013341654601396555, "content_hash": 8013341654601396555, "location": "func_datevalue.xhp", "context": "func_datevalue.xhp\npar_id0119200903491982\nhelp.text", "note": "cqHjd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6850, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111157958/?format=api", "priority": 100, "id": 112009525, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=ef351bc7425b714b", "url": "https://translations.documentfoundation.org/api/units/112009525/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:55.838981Z" } ] }{ "count": 8439, "next": "