diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-09-29 15:26:04 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-10-02 08:54:16 +0200 |
| commit | b358fb9b95915743d8666b238acb8e117c8751ce (patch) | |
| tree | 7913b29b55f56ffa83d7a7e57f96340db7536410 /source/text/scalc/01/func_networkdays.intl.xhp | |
| parent | tdf#103527 Remove Colors from Options help (diff) | |
| download | help-b358fb9b95915743d8666b238acb8e117c8751ce.tar.gz help-b358fb9b95915743d8666b238acb8e117c8751ce.zip | |
Reduce L10N workload for repetitive strings
Change 'Syntax' and 'Examples' heading into an embedded string
translated only once.
Change-Id: Iac2eef8fedbaa4461aa2f941af7f065a3b16fb2d
Reviewed-on: https://gerrit.libreoffice.org/61143
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/func_networkdays.intl.xhp')
| -rw-r--r-- | source/text/scalc/01/func_networkdays.intl.xhp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/func_networkdays.intl.xhp b/source/text/scalc/01/func_networkdays.intl.xhp index 77f272f514..ee355d7c17 100644 --- a/source/text/scalc/01/func_networkdays.intl.xhp +++ b/source/text/scalc/01/func_networkdays.intl.xhp @@ -34,14 +34,14 @@ <paragraph id="hd_id231020162211573602" role="heading" level="1" xml-lang="en-US"><variable id="networkdaysintl"><link href="text/scalc/01/func_networkdays.intl.xhp">NETWORKDAYS.INTL</link></variable></paragraph> <paragraph id="par_id231020162213393086" role="paragraph" xml-lang="en-US"><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></paragraph> </section> -<paragraph id="par_id231020162213395472" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id231020162249539143" role="code" xml-lang="en-US">NETWORKDAYS.INTL(StartDate; EndDate; Weekend; Holidays)</paragraph> <paragraph id="par_id231020162249533010" role="paragraph" xml-lang="en-US"><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.</paragraph> <paragraph id="par_id231020162249536398" role="paragraph" xml-lang="en-US"><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.</paragraph> <embed href="text/scalc/01/common_func_workdaysintl.xhp#embed_workdays_intl"/> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> -<paragraph id="hd_id231020162249551873" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id231020162249554032" role="paragraph" xml-lang="en-US">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.</paragraph> <paragraph id="par_id231020162249551234" role="paragraph" xml-lang="en-US"><item type="input">=NETWORKDAYS.INTL(C3;D3;;F3:J3)</item> returns 21 workdays with default for weekend days.</paragraph> <paragraph id="par_id231020162249553109" role="paragraph" xml-lang="en-US"><item type="input">=NETWORKDAYS.INTL(C3;D3;11;F3:J3)</item> returns 24 workdays with Sunday only weekends.</paragraph> |