diff options
| author | Vladimir Glazounov <vg@openoffice.org> | 2008-01-24 12:56:29 +0000 |
|---|---|---|
| committer | Vladimir Glazounov <vg@openoffice.org> | 2008-01-24 12:56:29 +0000 |
| commit | 52f463a1978b89cf19a78e5629004bef00b75fd3 (patch) | |
| tree | 7c5c1c0d896d281a86fcc6fd17fa23a0b506eedc /helpcontent2/source/text/scalc/01 | |
| parent | 93f6f6a47ecf77e66ab39b19aa901a827debd561 (diff) | |
INTEGRATION: CWS hcshared15 (1.4.266); FILE MERGED
2008/01/11 14:00:18 ufi 1.4.266.2: new makefiles und zwischenstand
2007/12/18 12:12:15 ufi 1.4.266.1: saving
Diffstat (limited to 'helpcontent2/source/text/scalc/01')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/func_day.xhp | 36 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/func_edate.xhp | 36 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/func_eomonth.xhp | 36 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/func_hour.xhp | 33 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/func_minute.xhp | 36 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/func_month.xhp | 33 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/func_second.xhp | 33 |
7 files changed, 125 insertions, 118 deletions
diff --git a/helpcontent2/source/text/scalc/01/func_day.xhp b/helpcontent2/source/text/scalc/01/func_day.xhp index 74d6704a9b..cbce5c4742 100644 --- a/helpcontent2/source/text/scalc/01/func_day.xhp +++ b/helpcontent2/source/text/scalc/01/func_day.xhp @@ -1,13 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> -<!--*********************************************************************** + +<!-- + *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: func_day.xhp,v $ + * $RCSfile: func_day.xhp,v $fileonly,v $ * - * $Revision: 1.4 $ + * $Revision: 1.5 $ * - * last change: $Author: rt $ $Date: 2005-09-07 18:02:31 $ + * last change: $Author: vg $ $Date: 2008-01-24 13:54:00 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -32,33 +34,33 @@ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * - ************************************************************************--> - -<helpdocument version="1.0"> + ************************************************************************ + --> + + + <helpdocument version="1.0"> <meta> <topic id="textscalc01func_dayxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">DAY </title> <filename>/text/scalc/01/func_day.xhp</filename> </topic> -<history> -<created date="2004-05-27T16:38:22"/> -<lastedited date="2004-07-20T14:18:41"/> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3147317"><bookmark_value>DAY function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_TAG" id="bm_id3151283" localize="false"/> -<paragraph role="heading" id="hd_id3147317" xml-lang="en-US" level="2" l10n="U" oldref="106"><variable id="day"><link href="text/scalc/01/func_day.xhp">DAY</link> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_TAG" id="bm_id3151283" localize="false"/><paragraph role="heading" id="hd_id3147317" xml-lang="en-US" level="2" l10n="U" oldref="106"><variable id="day"><link href="text/scalc/01/func_day.xhp">DAY</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3147584" xml-lang="en-US" l10n="U" oldref="107"><ahelp hid="HID_FUNC_TAG">Returns the day of given date value.</ahelp> The day is returned as an integer between 1 and 31. You can also enter a negative date/time value.</paragraph> <paragraph role="heading" id="hd_id3150487" xml-lang="en-US" level="3" l10n="U" oldref="108">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3149430" xml-lang="en-US" l10n="U" oldref="109">DAY(Number)</paragraph> +<paragraph role="code" id="par_id3149430" xml-lang="en-US" l10n="U" oldref="109">DAY(Number)</paragraph> <paragraph role="paragraph" id="par_id3149443" xml-lang="en-US" l10n="U" oldref="110"> <emph>Number</emph>, as a time value, is a decimal, for which the day is to be returned.</paragraph> <paragraph role="heading" id="hd_id3163809" xml-lang="en-US" level="3" l10n="U" oldref="111">Examples </paragraph> -<paragraph role="paragraph" id="par_id3151200" xml-lang="en-US" l10n="U" oldref="112">DAY(1) returns 31 (since $[officename] starts counting at zero from December 30, 1899)</paragraph> -<paragraph role="paragraph" id="par_id3154130" xml-lang="en-US" l10n="U" oldref="113">DAY(NOW()) returns the current day.</paragraph> -<paragraph role="paragraph" id="par_id3159190" xml-lang="en-US" l10n="U" oldref="114">DAY(C4) returns 5 if the contents of C4 = 8/5/1901.</paragraph> +<paragraph role="paragraph" id="par_id3151200" xml-lang="en-US" l10n="U" oldref="112"> +<item type="input">=DAY(1)</item> returns 31 (since $[officename] starts counting at zero from December 30, 1899)</paragraph> +<paragraph role="paragraph" id="par_id3154130" xml-lang="en-US" l10n="U" oldref="113"> +<item type="input">=DAY(NOW())</item> returns the current day.</paragraph> +<paragraph role="paragraph" id="par_id3159190" xml-lang="en-US" l10n="U" oldref="114"> +<item type="input">=DAY(C4)</item> returns 5 if the contents of C4 = <item type="input">8/5/1901</item>.</paragraph> </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/01/func_edate.xhp b/helpcontent2/source/text/scalc/01/func_edate.xhp index 8bc42e9f73..2c94363090 100644 --- a/helpcontent2/source/text/scalc/01/func_edate.xhp +++ b/helpcontent2/source/text/scalc/01/func_edate.xhp @@ -1,13 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> -<!--*********************************************************************** + +<!-- + *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: func_edate.xhp,v $ + * $RCSfile: func_edate.xhp,v $fileonly,v $ * - * $Revision: 1.4 $ + * $Revision: 1.5 $ * - * last change: $Author: rt $ $Date: 2005-09-07 18:03:37 $ + * last change: $Author: vg $ $Date: 2008-01-24 13:54:52 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -32,35 +34,33 @@ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * - ************************************************************************--> - -<helpdocument version="1.0"> + ************************************************************************ + --> + + + <helpdocument version="1.0"> <meta> <topic id="textscalc01func_edatexml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">EDATE</title> <filename>/text/scalc/01/func_edate.xhp</filename> </topic> -<history> -<created date="2004-05-19T17:45:18"/> -<lastedited date="2004-07-20T14:20:10"/> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3151184"><bookmark_value>EDATE function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_EDATE" id="bm_id3150761" localize="false"/> -<paragraph role="heading" id="hd_id3151184" xml-lang="en-US" level="2" l10n="U" oldref="213"><variable id="edate"><link href="text/scalc/01/func_edate.xhp">EDATE</link> +<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_EDATE" id="bm_id3150761" localize="false"/><paragraph role="heading" id="hd_id3151184" xml-lang="en-US" level="2" l10n="U" oldref="213"><variable id="edate"><link href="text/scalc/01/func_edate.xhp">EDATE</link> </variable></paragraph> <embed href="text/shared/00/00000001.xhp#add"/> -<paragraph role="paragraph" id="par_id3150880" xml-lang="en-US" l10n="U" oldref="214"><ahelp hid="HID_AAI_FUNC_EDATE">The result is a date which is a number of <emph>Months</emph> away from the <emph>Start date</emph>. Only months are considered; days are not used for calculation.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3150880" xml-lang="en-US" l10n="U" oldref="214"><ahelp hid="HID_AAI_FUNC_EDATE">The result is a date which is a number of m<emph>onths</emph> away from the <emph>start date</emph>. Only months are considered; days are not used for calculation.</ahelp></paragraph> <paragraph role="heading" id="hd_id3154647" xml-lang="en-US" level="3" l10n="U" oldref="215">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3153212" xml-lang="en-US" l10n="U" oldref="216">EDATE(Start date;Months)</paragraph> +<paragraph role="code" id="par_id3153212" xml-lang="en-US" l10n="U" oldref="216">EDATE(StartDate; Months)</paragraph> <paragraph role="paragraph" id="par_id3146860" xml-lang="en-US" l10n="U" oldref="217"> -<emph>Start date</emph>: a date.</paragraph> +<emph>StartDate</emph> is a date.</paragraph> <paragraph role="paragraph" id="par_id3152929" xml-lang="en-US" l10n="U" oldref="218"> -<emph>Months</emph>: the number of months.</paragraph> +<emph>Months</emph> is the number of months before (negative) or after (positive) the start date.</paragraph> <paragraph role="heading" id="hd_id3151289" xml-lang="en-US" level="3" l10n="U" oldref="219">Example</paragraph> <paragraph role="paragraph" id="par_id3155845" xml-lang="en-US" l10n="U" oldref="220">What date is one month prior to 3.31.2001?</paragraph> -<paragraph role="paragraph" id="par_id3155999" xml-lang="en-US" l10n="U" oldref="221">=EDATE("3.31.2001";-1) returns 2.28.2001.</paragraph> +<paragraph role="paragraph" id="par_id3155999" xml-lang="en-US" l10n="U" oldref="221"> +<item type="input">=EDATE(3.31.2001;-1)</item> returns 2.28.2001.</paragraph> </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/01/func_eomonth.xhp b/helpcontent2/source/text/scalc/01/func_eomonth.xhp index 0682df9ac8..210f374b86 100644 --- a/helpcontent2/source/text/scalc/01/func_eomonth.xhp +++ b/helpcontent2/source/text/scalc/01/func_eomonth.xhp @@ -1,13 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> -<!--*********************************************************************** + +<!-- + *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: func_eomonth.xhp,v $ + * $RCSfile: func_eomonth.xhp,v $fileonly,v $ * - * $Revision: 1.4 $ + * $Revision: 1.5 $ * - * last change: $Author: rt $ $Date: 2005-09-07 18:03:54 $ + * last change: $Author: vg $ $Date: 2008-01-24 13:55:05 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -32,35 +34,33 @@ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * - ************************************************************************--> - -<helpdocument version="1.0"> + ************************************************************************ + --> + + + <helpdocument version="1.0"> <meta> <topic id="textscalc01func_eomonthxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">EOMONTH</title> <filename>/text/scalc/01/func_eomonth.xhp</filename> </topic> -<history> -<created date="2004-05-19T17:57:53"/> -<lastedited date="2004-07-20T14:20:42"/> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3150991"><bookmark_value>EOMONTH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_EOMONTH" id="bm_id3158439" localize="false"/> -<paragraph role="heading" id="hd_id3150991" xml-lang="en-US" level="2" oldref="231"><variable id="eomonth"><link href="text/scalc/01/func_eomonth.xhp">EOMONTH</link> +<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_EOMONTH" id="bm_id3158439" localize="false"/><paragraph role="heading" id="hd_id3150991" xml-lang="en-US" level="2" oldref="231"><variable id="eomonth"><link href="text/scalc/01/func_eomonth.xhp">EOMONTH</link> </variable></paragraph> <embed href="text/shared/00/00000001.xhp#add"/> -<paragraph role="paragraph" id="par_id3152766" xml-lang="en-US" l10n="U" oldref="232"><ahelp hid="HID_AAI_FUNC_EOMONTH">Returns the date of the last day of a month which falls <emph>Months</emph> away from the <emph>Start date</emph>.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3152766" xml-lang="en-US" l10n="U" oldref="232"><ahelp hid="HID_AAI_FUNC_EOMONTH">Returns the date of the last day of a month which falls m<emph>onths</emph> away from the s<emph>tart date</emph>.</ahelp></paragraph> <paragraph role="heading" id="hd_id3150597" xml-lang="en-US" level="3" l10n="U" oldref="233">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3150351" xml-lang="en-US" l10n="U" oldref="234">EOMONTH (Start date; Months)</paragraph> +<paragraph role="code" id="par_id3150351" xml-lang="en-US" l10n="U" oldref="234">EOMONTH(StartDate; Months)</paragraph> <paragraph role="paragraph" id="par_id3146787" xml-lang="en-US" l10n="U" oldref="235"> -<emph>Start date</emph>: calculated from this point onwards.</paragraph> +<emph>StartDate</emph> is a date (the starting point of the calculation).</paragraph> <paragraph role="paragraph" id="par_id3155615" xml-lang="en-US" l10n="U" oldref="236"> -<emph>Months</emph>: the number of months before (negative) or after (positive) the Start Date.</paragraph> +<emph>Months</emph> is the number of months before (negative) or after (positive) the start date.</paragraph> <paragraph role="heading" id="hd_id3156335" xml-lang="en-US" level="3" l10n="U" oldref="237">Example</paragraph> <paragraph role="paragraph" id="par_id3154829" xml-lang="en-US" l10n="U" oldref="238">What is the last day of the month that falls 6 months after September 14 2001?</paragraph> -<paragraph role="paragraph" id="par_id3156143" xml-lang="en-US" l10n="U" oldref="239">=EOMONTH("9.14.2001";6) returns 3.31.2002.</paragraph> +<paragraph role="paragraph" id="par_id3156143" xml-lang="en-US" l10n="U" oldref="239"> +<item type="input">=EOMONTH(9.14.2001;6)</item> returns 3.31.2002.</paragraph> </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/01/func_hour.xhp b/helpcontent2/source/text/scalc/01/func_hour.xhp index 246d583de0..43c89a67cb 100644 --- a/helpcontent2/source/text/scalc/01/func_hour.xhp +++ b/helpcontent2/source/text/scalc/01/func_hour.xhp @@ -1,13 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> -<!--*********************************************************************** + +<!-- + *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: func_hour.xhp,v $ + * $RCSfile: func_hour.xhp,v $fileonly,v $ * - * $Revision: 1.4 $ + * $Revision: 1.5 $ * - * last change: $Author: rt $ $Date: 2005-09-07 18:04:12 $ + * last change: $Author: vg $ $Date: 2008-01-24 13:55:18 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -32,33 +34,32 @@ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * - ************************************************************************--> - -<helpdocument version="1.0"> + ************************************************************************ + --> + + + <helpdocument version="1.0"> <meta> <topic id="textscalc01func_hourxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">HOUR </title> <filename>/text/scalc/01/func_hour.xhp</filename> </topic> -<history> -<created date="2004-05-27T15:41:30"/> -<lastedited date="2004-07-20T14:21:03"/> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3154725"><bookmark_value>HOUR function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_STUNDE" id="bm_id3152469" localize="false"/> -<paragraph role="heading" id="hd_id3154725" xml-lang="en-US" level="2" l10n="U" oldref="96"><variable id="hour"><link href="text/scalc/01/func_hour.xhp">HOUR</link> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_STUNDE" id="bm_id3152469" localize="false"/><paragraph role="heading" id="hd_id3154725" xml-lang="en-US" level="2" l10n="U" oldref="96"><variable id="hour"><link href="text/scalc/01/func_hour.xhp">HOUR</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3149747" xml-lang="en-US" l10n="U" oldref="97"><ahelp hid="HID_FUNC_STUNDE">Returns the hour for a given time value.</ahelp> The hour is returned as an integer between 0 and 23.</paragraph> <paragraph role="heading" id="hd_id3149338" xml-lang="en-US" level="3" l10n="U" oldref="98">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3150637" xml-lang="en-US" l10n="U" oldref="99">HOUR(Number)</paragraph> +<paragraph role="code" id="par_id3150637" xml-lang="en-US" l10n="U" oldref="99">HOUR(Number)</paragraph> <paragraph role="paragraph" id="par_id3147547" xml-lang="en-US" l10n="U" oldref="100"> <emph>Number</emph>, as a time value, is a decimal, for which the hour is to be returned.</paragraph> <paragraph role="heading" id="hd_id3153264" xml-lang="en-US" level="3" l10n="U" oldref="101">Examples</paragraph> -<paragraph role="paragraph" id="par_id3159215" xml-lang="en-US" l10n="U" oldref="103">HOUR(NOW()) returns the current hour</paragraph> -<paragraph role="paragraph" id="par_id3145152" xml-lang="en-US" l10n="U" oldref="104">HOUR(C4) returns 17 if the contents of C4 = 17:20:00.</paragraph> +<paragraph role="paragraph" id="par_id3159215" xml-lang="en-US" l10n="U" oldref="103"> +<item type="input">=HOUR(NOW())</item> returns the current hour</paragraph> +<paragraph role="paragraph" id="par_id3145152" xml-lang="en-US" l10n="U" oldref="104"> +<item type="input">=HOUR(C4)</item> returns 17 if the contents of C4 = <item type="input">17:20:00</item>.</paragraph> <embed href="text/shared/00/00000001.xhp#siehe"/> <paragraph role="paragraph" id="par_id3154188" xml-lang="en-US" l10n="U" oldref="105"><link href="text/scalc/01/04060102.xhp" name="YEAR">YEAR</link>, <link href="text/scalc/01/04060102.xhp" name="NOW">NOW</link>, <link href="text/scalc/01/04060102.xhp" name="MINUTE">MINUTE</link>, <link href="text/scalc/01/04060102.xhp" name="MONTH">MONTH</link>, <link href="text/scalc/01/04060102.xhp" name="DAY">DAY</link>, <link href="text/scalc/01/04060102.xhp" name="WEEKDAY">WEEKDAY</link>.</paragraph> </body> diff --git a/helpcontent2/source/text/scalc/01/func_minute.xhp b/helpcontent2/source/text/scalc/01/func_minute.xhp index 516a90a92d..5b8b2740c3 100644 --- a/helpcontent2/source/text/scalc/01/func_minute.xhp +++ b/helpcontent2/source/text/scalc/01/func_minute.xhp @@ -1,13 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> -<!--*********************************************************************** + +<!-- + *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: func_minute.xhp,v $ + * $RCSfile: func_minute.xhp,v $fileonly,v $ * - * $Revision: 1.4 $ + * $Revision: 1.5 $ * - * last change: $Author: rt $ $Date: 2005-09-07 18:04:29 $ + * last change: $Author: vg $ $Date: 2008-01-24 13:55:31 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -32,33 +34,33 @@ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * - ************************************************************************--> - -<helpdocument version="1.0"> + ************************************************************************ + --> + + + <helpdocument version="1.0"> <meta> <topic id="textscalc01func_minutexml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">MINUTE </title> <filename>/text/scalc/01/func_minute.xhp</filename> </topic> -<history> -<created date="2004-05-19T17:55:04"/> -<lastedited date="2004-07-20T14:21:29"/> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3149803"><bookmark_value>MINUTE function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MINUTE" id="bm_id3148616" localize="false"/> -<paragraph role="heading" id="hd_id3149803" xml-lang="en-US" level="2" l10n="U" oldref="66"><variable id="minute"><link href="text/scalc/01/func_minute.xhp">MINUTE</link> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MINUTE" id="bm_id3148616" localize="false"/><paragraph role="heading" id="hd_id3149803" xml-lang="en-US" level="2" l10n="U" oldref="66"><variable id="minute"><link href="text/scalc/01/func_minute.xhp">MINUTE</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3148988" xml-lang="en-US" l10n="U" oldref="67"><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.</paragraph> <paragraph role="heading" id="hd_id3154343" xml-lang="en-US" level="3" l10n="U" oldref="68">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3148660" xml-lang="en-US" l10n="U" oldref="69">MINUTE(number)</paragraph> +<paragraph role="code" id="par_id3148660" xml-lang="en-US" l10n="U" oldref="69">MINUTE(Number)</paragraph> <paragraph role="paragraph" id="par_id3154611" xml-lang="en-US" l10n="U" oldref="70"> <emph>Number</emph>, as a time value, is a decimal number where the number of the minute is to be returned.</paragraph> <paragraph role="heading" id="hd_id3145374" xml-lang="en-US" level="3" l10n="U" oldref="71">Examples</paragraph> -<paragraph role="paragraph" id="par_id3148463" xml-lang="en-US" l10n="U" oldref="72">MINUTE(8.999) returns 58</paragraph> -<paragraph role="paragraph" id="par_id3149419" xml-lang="en-US" l10n="U" oldref="73">MINUTE(8.9999) returns 59</paragraph> -<paragraph role="paragraph" id="par_id3144755" xml-lang="en-US" l10n="U" oldref="74">MINUTE(NOW()) returns the current minute value.</paragraph> +<paragraph role="paragraph" id="par_id3148463" xml-lang="en-US" l10n="U" oldref="72"> +<item type="input">=MINUTE(8.999)</item> returns 58</paragraph> +<paragraph role="paragraph" id="par_id3149419" xml-lang="en-US" l10n="U" oldref="73"> +<item type="input">=MINUTE(8.9999)</item> returns 59</paragraph> +<paragraph role="paragraph" id="par_id3144755" xml-lang="en-US" l10n="U" oldref="74"> +<item type="input">=MINUTE(NOW())</item> returns the current minute value.</paragraph> </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/01/func_month.xhp b/helpcontent2/source/text/scalc/01/func_month.xhp index 01bff22379..35a71af950 100644 --- a/helpcontent2/source/text/scalc/01/func_month.xhp +++ b/helpcontent2/source/text/scalc/01/func_month.xhp @@ -1,13 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> -<!--*********************************************************************** + +<!-- + *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: func_month.xhp,v $ + * $RCSfile: func_month.xhp,v $fileonly,v $ * - * $Revision: 1.4 $ + * $Revision: 1.5 $ * - * last change: $Author: rt $ $Date: 2005-09-07 18:04:47 $ + * last change: $Author: vg $ $Date: 2008-01-24 13:55:43 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -32,32 +34,31 @@ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * - ************************************************************************--> - -<helpdocument version="1.0"> + ************************************************************************ + --> + + + <helpdocument version="1.0"> <meta> <topic id="textscalc01func_monthxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">MONTH </title> <filename>/text/scalc/01/func_month.xhp</filename> </topic> -<history> -<created date="2004-05-19T17:56:38"/> -<lastedited date="2004-07-20T14:22:01"/> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3149936"><bookmark_value>MONTH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MONAT" id="bm_id3150628" localize="false"/> -<paragraph role="heading" id="hd_id3149936" xml-lang="en-US" level="2" l10n="U" oldref="76"><variable id="month"><link href="text/scalc/01/func_month.xhp">MONTH</link> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MONAT" id="bm_id3150628" localize="false"/><paragraph role="heading" id="hd_id3149936" xml-lang="en-US" level="2" l10n="U" oldref="76"><variable id="month"><link href="text/scalc/01/func_month.xhp">MONTH</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3153538" xml-lang="en-US" l10n="U" oldref="77"><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.</paragraph> <paragraph role="heading" id="hd_id3149517" xml-lang="en-US" level="3" l10n="U" oldref="78">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3145602" xml-lang="en-US" l10n="U" oldref="79">MONTH(Number)</paragraph> +<paragraph role="code" id="par_id3145602" xml-lang="en-US" l10n="U" oldref="79">MONTH(Number)</paragraph> <paragraph role="paragraph" id="par_id3149485" xml-lang="en-US" l10n="U" oldref="80"> <emph>Number</emph>, as a time value, is a decimal for which the month is to be returned.</paragraph> <paragraph role="heading" id="hd_id3153322" xml-lang="en-US" level="3" l10n="U" oldref="81">Examples</paragraph> -<paragraph role="paragraph" id="par_id3149244" xml-lang="en-US" l10n="U" oldref="83">MONTH(NOW()) returns the current month</paragraph> -<paragraph role="paragraph" id="par_id3154790" xml-lang="en-US" l10n="U" oldref="84">MONTH(C4) returns 7 if contents of C4 = 7/7/00.</paragraph> +<paragraph role="paragraph" id="par_id3149244" xml-lang="en-US" l10n="U" oldref="83"> +<item type="input">=MONTH(NOW())</item> returns the current month</paragraph> +<paragraph role="paragraph" id="par_id3154790" xml-lang="en-US" l10n="U" oldref="84"> +<item type="input">=MONTH(C4)</item> returns 7 if contents of C4 = <item type="input">7/7/00</item>.</paragraph> </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/01/func_second.xhp b/helpcontent2/source/text/scalc/01/func_second.xhp index c5d6d7f23f..225ef3de0a 100644 --- a/helpcontent2/source/text/scalc/01/func_second.xhp +++ b/helpcontent2/source/text/scalc/01/func_second.xhp @@ -1,13 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> -<!--*********************************************************************** + +<!-- + *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: func_second.xhp,v $ + * $RCSfile: func_second.xhp,v $fileonly,v $ * - * $Revision: 1.4 $ + * $Revision: 1.5 $ * - * last change: $Author: rt $ $Date: 2005-09-07 18:05:49 $ + * last change: $Author: vg $ $Date: 2008-01-24 13:56:29 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -32,32 +34,31 @@ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * - ************************************************************************--> - -<helpdocument version="1.0"> + ************************************************************************ + --> + + + <helpdocument version="1.0"> <meta> <topic id="textscalc01func_secondxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">SECOND </title> <filename>/text/scalc/01/func_second.xhp</filename> </topic> -<history> -<created date="2004-05-27T15:39:41"/> -<lastedited date="2004-07-20T14:23:51"/> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3159390"><bookmark_value>SECOND function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_SEKUNDE" id="bm_id3155499" localize="false"/> -<paragraph role="heading" id="hd_id3159390" xml-lang="en-US" level="2" l10n="U" oldref="86"><variable id="second"><link href="text/scalc/01/func_second.xhp">SECOND</link> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_SEKUNDE" id="bm_id3155499" localize="false"/><paragraph role="heading" id="hd_id3159390" xml-lang="en-US" level="2" l10n="U" oldref="86"><variable id="second"><link href="text/scalc/01/func_second.xhp">SECOND</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3148974" xml-lang="en-US" l10n="U" oldref="87"><ahelp hid="HID_FUNC_SEKUNDE">Returns the second for the given time value.</ahelp> The second is given as an integer between 0 and 59.</paragraph> <paragraph role="heading" id="hd_id3154362" xml-lang="en-US" level="3" l10n="U" oldref="88">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3148407" xml-lang="en-US" l10n="U" oldref="89">SECOND(Number)</paragraph> +<paragraph role="code" id="par_id3148407" xml-lang="en-US" l10n="U" oldref="89">SECOND(Number)</paragraph> <paragraph role="paragraph" id="par_id3155904" xml-lang="en-US" l10n="U" oldref="90"> <emph>Number</emph>, as a time value, is a decimal, for which the second is to be returned.</paragraph> <paragraph role="heading" id="hd_id3149992" xml-lang="en-US" level="3" l10n="U" oldref="91">Examples</paragraph> -<paragraph role="paragraph" id="par_id3153350" xml-lang="en-US" l10n="U" oldref="93">SECOND(NOW()) returns the current second</paragraph> -<paragraph role="paragraph" id="par_id3150831" xml-lang="en-US" l10n="U" oldref="94">SECOND(C4) returns 17 if contents of C4 = 12:20:17.</paragraph> +<paragraph role="paragraph" id="par_id3153350" xml-lang="en-US" l10n="U" oldref="93"> +<item type="input">=SECOND(NOW())</item> returns the current second</paragraph> +<paragraph role="paragraph" id="par_id3150831" xml-lang="en-US" l10n="U" oldref="94"> +<item type="input">=SECOND(C4)</item> returns 17 if contents of C4 = <item type="input">12:20:17</item>.</paragraph> </body> </helpdocument> |