Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=145
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=146", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=144", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\">\"&MIN(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 2524283094541941754, "content_hash": 2524283094541941754, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id220502883332563\nhelp.text", "note": "7S443", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7201, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99324350/?format=api", "priority": 100, "id": 99530820, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a3080e19aab23bfa", "url": "https://translations.documentfoundation.org/api/units/99530820/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.716979Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range ending with \"book\" and to all cells of the B2:B6 range except its minimum. Returns 190." ], "previous_source": "", "target": [ "" ], "id_hash": 1511293224466033220, "content_hash": 1511293224466033220, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id15342189586295\nhelp.text", "note": "gNhzJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7202, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99324373/?format=api", "priority": 100, "id": 99530823, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=94f9312e33c0aa44", "url": "https://translations.documentfoundation.org/api/units/99530823/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.718453Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": 562770679139324109, "content_hash": 562770679139324109, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nhd_id8168283329426\nhelp.text", "note": "uz4wr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7203, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99324418/?format=api", "priority": 100, "id": 99530834, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=87cf5cf3741ad0cd", "url": "https://translations.documentfoundation.org/api/units/99530834/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.723137Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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 MINIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "" ], "id_hash": -6961485744941843957, "content_hash": -6961485744941843957, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id50762995519951\nhelp.text", "note": "27hDw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7204, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/99324438/?format=api", "priority": 100, "id": 99530849, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1f63d59937cbba0b", "url": "https://translations.documentfoundation.org/api/units/99530849/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.729273Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -4878672984956085105, "content_hash": -4878672984956085105, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id135761606425300\nhelp.text", "note": "EcoDf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7205, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99324457/?format=api", "priority": 100, "id": 99530857, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3c4b78c4bc65dc8f", "url": "https://translations.documentfoundation.org/api/units/99530857/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.733282Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If E2 = \"book\", the function returns 180, because the reference to the cell is substituted with its content." ], "previous_source": "", "target": [ "" ], "id_hash": -7124754506057414550, "content_hash": -7124754506057414550, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id30574750215839\nhelp.text", "note": "cxmqK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7206, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99324465/?format=api", "priority": 100, "id": 99530867, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1d1fc9867a95886a", "url": "https://translations.documentfoundation.org/api/units/99530867/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.737622Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINIFS\">MINIFS wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -4642634868378127656, "content_hash": -4642634868378127656, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id941677015454359\nhelp.text", "note": "zBVgq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7207, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99324475/?format=api", "priority": 100, "id": 99530873, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3f920c2f587ab2d8", "url": "https://translations.documentfoundation.org/api/units/99530873/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.741257Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "MINUTE" ], "previous_source": "", "target": [ "MINUTU" ], "id_hash": 6583649393914450800, "content_hash": 6583649393914450800, "location": "func_minute.xhp", "context": "func_minute.xhp\ntit\nhelp.text", "note": "SAxB8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7208, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99324483/?format=api", "priority": 100, "id": 99530875, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=db5dd23df9fc9370", "url": "https://translations.documentfoundation.org/api/units/99530875/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.743438Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>MINUTE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>MINUTU</bookmark_value>" ], "id_hash": 6674063580216568736, "content_hash": 6674063580216568736, "location": "func_minute.xhp", "context": "func_minute.xhp\nbm_id3149803\nhelp.text", "note": "7cQwC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7209, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99324488/?format=api", "priority": 100, "id": 99530878, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=dc9f09772b2e2ba0", "url": "https://translations.documentfoundation.org/api/units/99530878/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.745646Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"minute\"><link href=\"text/scalc/01/func_minute.xhp\">MINUTE</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"minute\"><link href=\"text/scalc/01/func_minute.xhp\">MINUTU</link></variable>" ], "id_hash": -6278203477099020855, "content_hash": -6278203477099020855, "location": "func_minute.xhp", "context": "func_minute.xhp\nhd_id3149803\nhelp.text", "note": "aFbYG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7210, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99324492/?format=api", "priority": 100, "id": 99530885, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=28df57336fe3fdc9", "url": "https://translations.documentfoundation.org/api/units/99530885/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.750875Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_MINUTE\">Calculates the minute for an internal time value.</ahelp> The minute is returned as a number between 0 and 59." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_MINUTE\">Calcula'l minutu que correspuende a un valor de tiempu internu.</ahelp> El minutu ye devueltu como un númberu ente 0 y 59." ], "id_hash": 3800930512976531485, "content_hash": 3800930512976531485, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3148988\nhelp.text", "note": "kGsA6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7211, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99324517/?format=api", "priority": 100, "id": 99530892, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b4bf9e29d1e8d01d", "url": "https://translations.documentfoundation.org/api/units/99530892/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.755270Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "MINUTE(Number)" ], "previous_source": "", "target": [ "MINUTU(Númberu)" ], "id_hash": -2617622125915151773, "content_hash": -2617622125915151773, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3148660\nhelp.text", "note": "LeQE8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7212, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99324528/?format=api", "priority": 100, "id": 99530908, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5bac568b949fe263", "url": "https://translations.documentfoundation.org/api/units/99530908/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.765828Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Number</emph>, as a time value, is a decimal number where the number of the minute is to be returned." ], "previous_source": "", "target": [ "El <emph>númberu</emph>, como valor temporal, ye un númberu decimal en función del cual tien de calculase'l númberu de minutos." ], "id_hash": 316469162102282401, "content_hash": 316469162102282401, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3154611\nhelp.text", "note": "8eGft", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7213, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99324554/?format=api", "priority": 100, "id": 99530913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=84645306b578d8a1", "url": "https://translations.documentfoundation.org/api/units/99530913/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.767638Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=MINUTE(8.999)</item> returns 58" ], "previous_source": "", "target": [ "<item type=\"input\">=MINUTU(8.999)</item> devuelve 58" ], "id_hash": -4031844472942077863, "content_hash": -4031844472942077863, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3148463\nhelp.text", "note": "L77op", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7214, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99324591/?format=api", "priority": 100, "id": 99530920, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=480c02d040aa5859", "url": "https://translations.documentfoundation.org/api/units/99530920/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.769582Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=MINUTE(8.9999)</item> returns 59" ], "previous_source": "", "target": [ "<item type=\"input\">=MINUTU(8.9999)</item> devuelve 59" ], "id_hash": 84806460256062177, "content_hash": 84806460256062177, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3149419\nhelp.text", "note": "Q9MMh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7215, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99324603/?format=api", "priority": 100, "id": 99530928, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=812d4b06ba388ae1", "url": "https://translations.documentfoundation.org/api/units/99530928/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.773452Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=MINUTE(NOW())</item> returns the current minute value." ], "previous_source": "", "target": [ "<item type=\"input\">=MINUTU(AGORA())</item> devuelve'l valor del minutu actual." ], "id_hash": 2679086020157768697, "content_hash": 2679086020157768697, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3144755\nhelp.text", "note": "A3T6A", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7216, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99324609/?format=api", "priority": 100, "id": 99530934, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a52e068a7a3803f9", "url": "https://translations.documentfoundation.org/api/units/99530934/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.775557Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINUTE\">MINUTE wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 4767693504299819361, "content_hash": 4767693504299819361, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id831677015434176\nhelp.text", "note": "FZ8uE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7217, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99324624/?format=api", "priority": 100, "id": 99530939, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c22a3ffb59ba6161", "url": "https://translations.documentfoundation.org/api/units/99530939/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.777559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "MONTH" ], "previous_source": "", "target": [ "MES" ], "id_hash": 6638587523359451547, "content_hash": 6638587523359451547, "location": "func_month.xhp", "context": "func_month.xhp\ntit\nhelp.text", "note": "FmPSf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7218, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99324643/?format=api", "priority": 100, "id": 99530952, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=dc21002e042e299b", "url": "https://translations.documentfoundation.org/api/units/99530952/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.782335Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>MONTH function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>MES</bookmark_value>" ], "id_hash": 2244101083469760134, "content_hash": 2244101083469760134, "location": "func_month.xhp", "context": "func_month.xhp\nbm_id3149936\nhelp.text", "note": "WdxqW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7219, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99324672/?format=api", "priority": 100, "id": 99530957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9f24a60bb048c686", "url": "https://translations.documentfoundation.org/api/units/99530957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.783945Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"month\"><link href=\"text/scalc/01/func_month.xhp\">MONTH</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"month\"><link href=\"text/scalc/01/func_month.xhp\">MES</link></variable>" ], "id_hash": 7376523598928593085, "content_hash": 7376523598928593085, "location": "func_month.xhp", "context": "func_month.xhp\nhd_id3149936\nhelp.text", "note": "oMx2Y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7220, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99324688/?format=api", "priority": 100, "id": 99530964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e65ead21776cc0bd", "url": "https://translations.documentfoundation.org/api/units/99530964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.785887Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_MONAT\">Returns the month for the given date value.</ahelp> The month is returned as an integer between 1 and 12." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_MONAT\">Devuelve'l mes pal valor de fecha determináu.</ahelp> El mes devuélvese como un enteru ente 1 y 12." ], "id_hash": 2811239148140080023, "content_hash": 2811239148140080023, "location": "func_month.xhp", "context": "func_month.xhp\npar_id3153538\nhelp.text", "note": "on6C8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7221, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99324704/?format=api", "priority": 100, "id": 99530971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a703871c538fab97", "url": "https://translations.documentfoundation.org/api/units/99530971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.787638Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "MONTH(Number)" ], "previous_source": "", "target": [ "MES(númberu)" ], "id_hash": -5996380274444024011, "content_hash": -5996380274444024011, "location": "func_month.xhp", "context": "func_month.xhp\npar_id3145602\nhelp.text", "note": "DFzsG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7222, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99324713/?format=api", "priority": 100, "id": 99530977, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2cc893e91b9ac735", "url": "https://translations.documentfoundation.org/api/units/99530977/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.789491Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Number</emph> is the internal date number." ], "previous_source": "", "target": [ "" ], "id_hash": 2018658085685654366, "content_hash": 2018658085685654366, "location": "func_month.xhp", "context": "func_month.xhp\npar_id3149485\nhelp.text", "note": "G77xy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7223, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99324730/?format=api", "priority": 100, "id": 99530982, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9c03b6d56843735e", "url": "https://translations.documentfoundation.org/api/units/99530982/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.791046Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=MONTH(NOW())</item> returns the current month." ], "previous_source": "", "target": [ "" ], "id_hash": -7592377325733978034, "content_hash": -7592377325733978034, "location": "func_month.xhp", "context": "func_month.xhp\npar_id3149244\nhelp.text", "note": "LuUhY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7224, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99324787/?format=api", "priority": 100, "id": 99530987, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=16a2750c62e5604e", "url": "https://translations.documentfoundation.org/api/units/99530987/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.792506Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=MONTH(C4)</item> returns 7 if you enter 2000-07-07 to cell C4 (that date value might get formatted differently after you press Enter)." ], "previous_source": "", "target": [ "" ], "id_hash": -8491534444649262145, "content_hash": -8491534444649262145, "location": "func_month.xhp", "context": "func_month.xhp\npar_id3154790\nhelp.text", "note": "BD2Ww", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7225, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/99324833/?format=api", "priority": 100, "id": 99530993, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0a280269a4afd3bf", "url": "https://translations.documentfoundation.org/api/units/99530993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.793923Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MONTH\">MONTH wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 4679861971459313363, "content_hash": 4679861971459313363, "location": "func_month.xhp", "context": "func_month.xhp\npar_id601677015418666\nhelp.text", "note": "J9sqE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7226, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99324896/?format=api", "priority": 100, "id": 99530997, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c0f235ab06b10ed3", "url": "https://translations.documentfoundation.org/api/units/99530997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.795397Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "NETWORKDAYS.INTL" ], "previous_source": "", "target": [ "" ], "id_hash": -4839283120033532648, "content_hash": -4839283120033532648, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\ntit\nhelp.text", "note": "kbyFK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7227, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99324922/?format=api", "priority": 100, "id": 99531003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3cd769a456db7518", "url": "https://translations.documentfoundation.org/api/units/99531003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.798402Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>NETWORKDAYS.INTL function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 7463221094156719831, "content_hash": 7463221094156719831, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\nbm_id231020162321219565\nhelp.text", "note": "H92rh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7228, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99324939/?format=api", "priority": 100, "id": 99531009, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e792b00b1569d6d7", "url": "https://translations.documentfoundation.org/api/units/99531009/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.800873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"networkdaysintl\"><link href=\"text/scalc/01/func_networkdays.intl.xhp\">NETWORKDAYS.INTL</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -6812576298881804812, "content_hash": -6812576298881804812, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\nhd_id231020162211573602\nhelp.text", "note": "54nta", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7229, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99324977/?format=api", "priority": 100, "id": 99531019, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2174ddf363e795f4", "url": "https://translations.documentfoundation.org/api/units/99531019/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.804723Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\".\">Returns the number of workdays between a start date and an end date. There are options to define weekend days and holidays. The optional weekend parameter (or a string) can be used to define the weekend days (or the non-working days in each week). Also, optionally, the user can define a holiday list. The weekend days and user-defined holidays are not counted as working days.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 8234703453306549382, "content_hash": 8234703453306549382, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162213393086\nhelp.text", "note": "kDcRW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7230, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 66, "source_unit": "https://translations.documentfoundation.org/api/units/99324991/?format=api", "priority": 100, "id": 99531024, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f2478b295504f486", "url": "https://translations.documentfoundation.org/api/units/99531024/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.806837Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "NETWORKDAYS.INTL(StartDate; EndDate [; [ Weekend ] [; Holidays ] ])" ], "previous_source": "", "target": [ "" ], "id_hash": -1750825525310235799, "content_hash": -1750825525310235799, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249539143\nhelp.text", "note": "53kNC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7231, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99325022/?format=api", "priority": 100, "id": 99531030, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=67b3d17604325b69", "url": "https://translations.documentfoundation.org/api/units/99531030/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.808932Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>StartDate</emph> is the date from when the calculation is carried out. If the start date is a workday, the day is included in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": 4847327864803132175, "content_hash": 4847327864803132175, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249533010\nhelp.text", "note": "D8jig", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7232, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99325074/?format=api", "priority": 100, "id": 99531038, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c3452b02c371830f", "url": "https://translations.documentfoundation.org/api/units/99531038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.812495Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>EndDate</emph> is the date up until when the calculation is carried out. If the end date is a workday, the day is included in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -6632844920074557198, "content_hash": -6632844920074557198, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249536398\nhelp.text", "note": "DU9WK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7233, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99325165/?format=api", "priority": 100, "id": 99531044, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=23f366b000b3a8f2", "url": "https://translations.documentfoundation.org/api/units/99531044/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.814727Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "How many workdays fall between December 15, 2016 and January 14, 2017? Let the start date be located in C3 and the end date in D3. Cells F3 to J3 contain five (5) holidays for Christmas and New Year in date format: December 24, 2016; December 25, 2016; December 26, 2016; December 31, 2016; and January 1, 2017." ], "previous_source": "", "target": [ "" ], "id_hash": 864578906826754154, "content_hash": 864578906826754154, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249554032\nhelp.text", "note": "Yhepz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7234, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 58, "source_unit": "https://translations.documentfoundation.org/api/units/99325209/?format=api", "priority": 100, "id": 99531049, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8bff99ef5db4486a", "url": "https://translations.documentfoundation.org/api/units/99531049/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.817181Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3;;F3:J3)</item> returns 21 workdays with default for weekend days." ], "previous_source": "", "target": [ "" ], "id_hash": -1198226530928746079, "content_hash": -1198226530928746079, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249551234\nhelp.text", "note": "YtSPd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7235, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99325246/?format=api", "priority": 100, "id": 99531061, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6f5f0b518f8b21a1", "url": "https://translations.documentfoundation.org/api/units/99531061/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.821612Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3;11;F3:J3)</item> returns 24 workdays with Sunday only weekends." ], "previous_source": "", "target": [ "" ], "id_hash": 9100411151027385989, "content_hash": 9100411151027385989, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249553109\nhelp.text", "note": "Q4DCf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7236, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99325368/?format=api", "priority": 100, "id": 99531065, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=fe4b27b9cefdb685", "url": "https://translations.documentfoundation.org/api/units/99531065/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.823498Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Alternatively, use the weekend string “0000001” to define Sunday as the non-working day of every week." ], "previous_source": "", "target": [ "" ], "id_hash": 4448288852589302287, "content_hash": 4448288852589302287, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249557786\nhelp.text", "note": "3AN56", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7237, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99325411/?format=api", "priority": 100, "id": 99531070, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bdbb7f24b4ea520f", "url": "https://translations.documentfoundation.org/api/units/99531070/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.825464Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3;“0000001”;F3:J3)</item> returns 24 workdays with Sunday only weekend." ], "previous_source": "", "target": [ "" ], "id_hash": -3166290266284883321, "content_hash": -3166290266284883321, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249553409\nhelp.text", "note": "2E4Jz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7238, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99325413/?format=api", "priority": 100, "id": 99531075, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=540f13c74e500287", "url": "https://translations.documentfoundation.org/api/units/99531075/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.827281Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The function can be used without the two optional parameters – weekday and holidays – by leaving them out:" ], "previous_source": "", "target": [ "" ], "id_hash": 3523748255882764074, "content_hash": 3523748255882764074, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249556946\nhelp.text", "note": "spLva", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7239, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99325461/?format=api", "priority": 100, "id": 99531078, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b0e6de5e7dcb5f2a", "url": "https://translations.documentfoundation.org/api/units/99531078/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.828789Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3)</item> gives 22 working days." ], "previous_source": "", "target": [ "" ], "id_hash": -6078042120183448005, "content_hash": -6078042120183448005, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id23102016224955931\nhelp.text", "note": "7pyBD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7240, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99325501/?format=api", "priority": 100, "id": 99531092, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2ba674e5009a7e3b", "url": "https://translations.documentfoundation.org/api/units/99531092/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.834723Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/NETWORKDAYS.INTL\">NETWORKDAYS.INTL wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -8929255920039199863, "content_hash": -8929255920039199863, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id421677015404173\nhelp.text", "note": "phSgD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7241, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99325530/?format=api", "priority": 100, "id": 99531095, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0414e90cc9827b89", "url": "https://translations.documentfoundation.org/api/units/99531095/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.836453Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "NETWORKDAYS" ], "previous_source": "", "target": [ "DIAS.LAB" ], "id_hash": 6561889438946436823, "content_hash": 6561889438946436823, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\ntit\nhelp.text", "note": "winzV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7242, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99325554/?format=api", "priority": 100, "id": 99531105, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=db1083ada7ca26d7", "url": "https://translations.documentfoundation.org/api/units/99531105/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.840331Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>NETWORKDAYS function</bookmark_value> <bookmark_value>NETWORKDAYS_EXCEL2003 function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 1044781252457136492, "content_hash": 1044781252457136492, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\nbm_id3151254\nhelp.text", "note": "v4yGQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7243, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99325580/?format=api", "priority": 100, "id": 99531113, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8e7fcf037cb2016c", "url": "https://translations.documentfoundation.org/api/units/99531113/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.844248Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"networkdays\"><link href=\"text/scalc/01/func_networkdays.xhp\">NETWORKDAYS</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 3573564113777338718, "content_hash": 3573564113777338718, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\nhd_id3151254\nhelp.text", "note": "HzF8v", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7244, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99325609/?format=api", "priority": 100, "id": 99531118, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b197d9a0bfc8295e", "url": "https://translations.documentfoundation.org/api/units/99531118/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.846330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_AAI_FUNC_NETWORKDAYS\">Returns the number of workdays between a <emph>start date</emph> and an <emph>end date</emph>. Holidays can be deducted.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -3352541134665369822, "content_hash": -3352541134665369822, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id3153788\nhelp.text", "note": "8M3zv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7245, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99325636/?format=api", "priority": 100, "id": 99531129, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=51796199bd62b722", "url": "https://translations.documentfoundation.org/api/units/99531129/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.850790Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "NETWORKDAYS(StartDate; EndDate [; [ Holidays ] [; Workdays ] ])" ], "previous_source": "", "target": [ "" ], "id_hash": -7130350855439197623, "content_hash": -7130350855439197623, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id3145775\nhelp.text", "note": "AME9S", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7246, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99325660/?format=api", "priority": 100, "id": 99531135, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1d0be7acd9a4da49", "url": "https://translations.documentfoundation.org/api/units/99531135/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.853140Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>StartDate</emph> is the date from when the calculation is carried out. If the start date is a workday, the day is included in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -178825624272293591, "content_hash": -178825624272293591, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id3153885\nhelp.text", "note": "BEtbU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7247, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99325687/?format=api", "priority": 100, "id": 99531141, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7d84af0acc833129", "url": "https://translations.documentfoundation.org/api/units/99531141/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.855379Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>EndDate</emph> is the date up until when the calculation is carried out. If the end date is a workday, the day is included in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -1814355179217094544, "content_hash": -1814355179217094544, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id3151110\nhelp.text", "note": "N9CAv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7248, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99325749/?format=api", "priority": 100, "id": 99531150, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=66d21d93ce5ff870", "url": "https://translations.documentfoundation.org/api/units/99531150/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.859004Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Holidays</emph> is an optional list of holidays. These are non-working days. Enter a cell range in which the holidays are listed individually." ], "previous_source": "", "target": [ "" ], "id_hash": -2701915441202722087, "content_hash": -2701915441202722087, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id3154115\nhelp.text", "note": "Zxfr2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7249, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/99325789/?format=api", "priority": 100, "id": 99531155, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5a80de38b9f80ad9", "url": "https://translations.documentfoundation.org/api/units/99531155/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.860941Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Workdays</emph> is an optional list of number values defining standard work week. This list starts by Sunday, workdays are indicated by zero and non-working days by non-zero value." ], "previous_source": "", "target": [ "" ], "id_hash": 4468315047788247129, "content_hash": 4468315047788247129, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id160920161749585013\nhelp.text", "note": "UTwRH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7250, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99325821/?format=api", "priority": 100, "id": 99531160, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=be02a4dc9ff37859", "url": "https://translations.documentfoundation.org/api/units/99531160/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.862903Z" } ] }