diff options
author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-05-13 12:06:07 -0300 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-05-14 12:42:57 +0200 |
commit | bc1435efdd13fb2f2b6cf78e946c7836db54d9c8 (patch) | |
tree | 0b0c688a4fe1457c52e06dc4842d670b9f523228 /source/text | |
parent | 71a04be1be73ec7cd27e14e152c01521b3c4b33e (diff) |
tdf#127477 Description of date & time functions in the help
Add precision on rounding and trunking of date and time values
SECOND() rounds value to nearest integer
MINUTE, HOUR, DAY, MONTH, YEAR truncates to integer part.
Change-Id: I115557dd85a9328185b197abfcd233b62b0beb78
reference: https://bugs.documentfoundation.org/show_bug.cgi?id=127476#c9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167605
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text')
-rw-r--r-- | source/text/scalc/01/func_day.xhp | 19 | ||||
-rw-r--r-- | source/text/scalc/01/func_hour.xhp | 17 | ||||
-rw-r--r-- | source/text/scalc/01/func_minute.xhp | 19 | ||||
-rw-r--r-- | source/text/scalc/01/func_month.xhp | 19 | ||||
-rw-r--r-- | source/text/scalc/01/func_second.xhp | 17 | ||||
-rw-r--r-- | source/text/scalc/01/func_year.xhp | 19 |
6 files changed, 58 insertions, 52 deletions
diff --git a/source/text/scalc/01/func_day.xhp b/source/text/scalc/01/func_day.xhp index 434f5bae47..94242055a9 100644 --- a/source/text/scalc/01/func_day.xhp +++ b/source/text/scalc/01/func_day.xhp @@ -19,26 +19,27 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc01func_dayxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">DAY </title> +<title id="tit">DAY </title> <filename>/text/scalc/01/func_day.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3147317"><bookmark_value>DAY function</bookmark_value> +<bookmark branch="index" id="bm_id3147317"><bookmark_value>DAY function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAG" id="bm_id3151283" localize="false"/><h1 id="hd_id3147317"><variable id="day"><link href="text/scalc/01/func_day.xhp">DAY</link> +<bookmark branch="hid/SC_HID_FUNC_TAG" id="bm_id3151283" localize="false"/><h1 id="hd_id3147317"><variable id="day"><link href="text/scalc/01/func_day.xhp">DAY</link> </variable></h1> -<paragraph role="paragraph" id="par_id3147584" xml-lang="en-US"><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="paragraph" id="par_id3147584"><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> <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph role="code" id="par_id3149430" xml-lang="en-US">DAY(Number)</paragraph> -<paragraph role="paragraph" id="par_id3149443" xml-lang="en-US"><emph>Number</emph> is the internal date number.</paragraph> +<paragraph role="code" id="par_id3149430">DAY(Number)</paragraph> +<paragraph role="paragraph" id="par_id3149443"><emph>Number</emph> is the internal date number.</paragraph> +<note id="par_id451715611481885">DAY() returns the integer part of the day.</note> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> -<paragraph role="paragraph" id="par_id3151200" xml-lang="en-US"><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"><item type="input">=DAY(NOW())</item> returns the current day.</paragraph> -<paragraph role="paragraph" id="par_id3159190" xml-lang="en-US"><item type="input">=DAY(C4)</item> returns 5 if you enter 1901-08-05 in cell C4 (the date value might get formatted differently after you press Enter).</paragraph> +<paragraph role="paragraph" id="par_id3151200"><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"><item type="input">=DAY(NOW())</item> returns the current day.</paragraph> +<paragraph role="paragraph" id="par_id3159190"><item type="input">=DAY(C4)</item> returns 5 if you enter 1901-08-05 in cell C4 (the date value might get formatted differently after you press Enter).</paragraph> <section id="relatedtopics"> <tip id="par_id951677016613386"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/DAY">DAY wiki page</link>.</tip> <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> diff --git a/source/text/scalc/01/func_hour.xhp b/source/text/scalc/01/func_hour.xhp index 90f4afec5b..89af023368 100644 --- a/source/text/scalc/01/func_hour.xhp +++ b/source/text/scalc/01/func_hour.xhp @@ -19,26 +19,27 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc01func_hourxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">HOUR </title> +<title id="tit">HOUR </title> <filename>/text/scalc/01/func_hour.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3154725"><bookmark_value>HOUR function</bookmark_value> +<bookmark branch="index" id="bm_id3154725"><bookmark_value>HOUR function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STUNDE" id="bm_id3152469" localize="false"/> +<bookmark branch="hid/SC_HID_FUNC_STUNDE" id="bm_id3152469" localize="false"/> <h1 id="hd_id3154725"><variable id="hour"><link href="text/scalc/01/func_hour.xhp">HOUR</link> </variable></h1> -<paragraph role="paragraph" id="par_id3149747" xml-lang="en-US"><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="paragraph" id="par_id3149747"><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> <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph role="code" id="par_id3150637" xml-lang="en-US">HOUR(Number)</paragraph> -<paragraph role="paragraph" id="par_id3147547" xml-lang="en-US"> +<paragraph role="code" id="par_id3150637">HOUR(Number)</paragraph> +<paragraph role="paragraph" id="par_id3147547"> <emph>Number</emph>, as a time value, is a decimal, for which the hour is to be returned.</paragraph> +<note id="par_id451715611481885">HOUR() returns the integer part of the hour.</note> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> -<paragraph role="paragraph" id="par_id3159215" xml-lang="en-US"> +<paragraph role="paragraph" id="par_id3159215"> <item type="input">=HOUR(NOW())</item> returns the current hour</paragraph> -<paragraph role="paragraph" id="par_id3145152" xml-lang="en-US"> +<paragraph role="paragraph" id="par_id3145152"> <item type="input">=HOUR(C4)</item> returns 17 if the contents of C4 = <item type="input">17:20:00</item>.</paragraph> <section id="relatedtopics"> <tip id="par_id851677015767824"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/HOUR">HOUR wiki page</link>.</tip> diff --git a/source/text/scalc/01/func_minute.xhp b/source/text/scalc/01/func_minute.xhp index 3c1b5275cf..8b5021dba0 100644 --- a/source/text/scalc/01/func_minute.xhp +++ b/source/text/scalc/01/func_minute.xhp @@ -19,28 +19,29 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc01func_minutexml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">MINUTE</title> +<title id="tit">MINUTE</title> <filename>/text/scalc/01/func_minute.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3149803"><bookmark_value>MINUTE function</bookmark_value> +<bookmark branch="index" id="bm_id3149803"><bookmark_value>MINUTE function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINUTE" id="bm_id3148616" localize="false"/> +<bookmark branch="hid/SC_HID_FUNC_MINUTE" id="bm_id3148616" localize="false"/> <h1 id="hd_id3149803"><variable id="minute"><link href="text/scalc/01/func_minute.xhp">MINUTE</link> </variable></h1> -<paragraph role="paragraph" id="par_id3148988" xml-lang="en-US"><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="paragraph" id="par_id3148988"><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> <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph role="code" id="par_id3148660" xml-lang="en-US">MINUTE(Number)</paragraph> -<paragraph role="paragraph" id="par_id3154611" xml-lang="en-US"> +<paragraph role="code" id="par_id3148660">MINUTE(Number)</paragraph> +<paragraph role="paragraph" id="par_id3154611"> <emph>Number</emph>, as a time value, is a decimal number where the number of the minute is to be returned.</paragraph> +<note id="par_id451715611481885">MINUTE() returns the integer part of the minute.</note> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> -<paragraph role="paragraph" id="par_id3148463" xml-lang="en-US"> +<paragraph role="paragraph" id="par_id3148463"> <item type="input">=MINUTE(8.999)</item> returns 58</paragraph> -<paragraph role="paragraph" id="par_id3149419" xml-lang="en-US"> +<paragraph role="paragraph" id="par_id3149419"> <item type="input">=MINUTE(8.9999)</item> returns 59</paragraph> -<paragraph role="paragraph" id="par_id3144755" xml-lang="en-US"> +<paragraph role="paragraph" id="par_id3144755"> <item type="input">=MINUTE(NOW())</item> returns the current minute value.</paragraph> <section id="relatedtopics"> <tip id="par_id831677015434176"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINUTE">MINUTE wiki page</link>.</tip> diff --git a/source/text/scalc/01/func_month.xhp b/source/text/scalc/01/func_month.xhp index efba950ddc..0213a7981c 100644 --- a/source/text/scalc/01/func_month.xhp +++ b/source/text/scalc/01/func_month.xhp @@ -19,27 +19,28 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc01func_monthxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">MONTH </title> +<title id="tit">MONTH </title> <filename>/text/scalc/01/func_month.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3149936"><bookmark_value>MONTH function</bookmark_value> +<bookmark branch="index" id="bm_id3149936"><bookmark_value>MONTH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MONAT" id="bm_id3150628" localize="false"/> +<bookmark branch="hid/SC_HID_FUNC_MONAT" id="bm_id3150628" localize="false"/> <h1 id="hd_id3149936"><variable id="month"><link href="text/scalc/01/func_month.xhp">MONTH</link> </variable></h1> -<paragraph role="paragraph" id="par_id3153538" xml-lang="en-US"><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="paragraph" id="par_id3153538"><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> <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph role="code" id="par_id3145602" xml-lang="en-US">MONTH(Number)</paragraph> -<paragraph role="paragraph" id="par_id3149485" xml-lang="en-US"> - <emph>Number</emph> is the internal date number.</paragraph> +<paragraph role="code" id="par_id3145602">MONTH(Number)</paragraph> +<paragraph role="paragraph" id="par_id3149485"> +<emph>Number</emph> is the internal date number.</paragraph> +<note id="par_id451715611481885">MONTH() returns the integer part of the month.</note> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> -<paragraph role="paragraph" id="par_id3149244" xml-lang="en-US"><item type="input">=MONTH(NOW())</item> returns the current month.</paragraph> -<paragraph role="paragraph" id="par_id3154790" xml-lang="en-US"><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).</paragraph> +<paragraph role="paragraph" id="par_id3149244"><item type="input">=MONTH(NOW())</item> returns the current month.</paragraph> +<paragraph role="paragraph" id="par_id3154790"><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).</paragraph> <section id="relatedtopics"> <tip id="par_id601677015418666"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MONTH">MONTH wiki page</link>.</tip> <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> diff --git a/source/text/scalc/01/func_second.xhp b/source/text/scalc/01/func_second.xhp index f2bebbcb56..7576e75007 100644 --- a/source/text/scalc/01/func_second.xhp +++ b/source/text/scalc/01/func_second.xhp @@ -19,26 +19,27 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc01func_secondxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">SECOND</title> +<title id="tit">SECOND</title> <filename>/text/scalc/01/func_second.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3159390"><bookmark_value>SECOND function</bookmark_value> +<bookmark branch="index" id="bm_id3159390"><bookmark_value>SECOND function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SEKUNDE" id="bm_id3155499" localize="false"/> +<bookmark branch="hid/SC_HID_FUNC_SEKUNDE" id="bm_id3155499" localize="false"/> <h1 id="hd_id3159390"><variable id="second"><link href="text/scalc/01/func_second.xhp">SECOND</link> </variable></h1> -<paragraph role="paragraph" id="par_id3148974" xml-lang="en-US"><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="paragraph" id="par_id3148974"><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> <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph role="code" id="par_id3148407" xml-lang="en-US">SECOND(Number)</paragraph> -<paragraph role="paragraph" id="par_id3155904" xml-lang="en-US"> +<paragraph role="code" id="par_id3148407">SECOND(Number)</paragraph> +<paragraph role="paragraph" id="par_id3155904"> <emph>Number</emph>, as a time value, is a decimal, for which the second is to be returned.</paragraph> +<note id="par_id451715611481885">SECOND() rounds to the nearest second, instead of returning the integer part of the seconds.</note> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> -<paragraph role="paragraph" id="par_id3153350" xml-lang="en-US"> +<paragraph role="paragraph" id="par_id3153350"> <item type="input">=SECOND(NOW())</item> returns the current second</paragraph> -<paragraph role="paragraph" id="par_id3150831" xml-lang="en-US"> +<paragraph role="paragraph" id="par_id3150831"> <item type="input">=SECOND(C4)</item> returns 17 if contents of C4 = <item type="input">12:20:17</item>.</paragraph> <section id="relatedtopics"> <tip id="par_id71677014729834"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SECOND">SECOND wiki page</link>.</tip> diff --git a/source/text/scalc/01/func_year.xhp b/source/text/scalc/01/func_year.xhp index 0bdbab6f39..be09c371eb 100644 --- a/source/text/scalc/01/func_year.xhp +++ b/source/text/scalc/01/func_year.xhp @@ -19,28 +19,29 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc01func_yearxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">YEAR</title> +<title id="tit">YEAR</title> <filename>/text/scalc/01/func_year.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3153982"><bookmark_value>YEAR function</bookmark_value> +<bookmark branch="index" id="bm_id3153982"><bookmark_value>YEAR function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JAHR" id="bm_id3159179" localize="false"/> +<bookmark branch="hid/SC_HID_FUNC_JAHR" id="bm_id3159179" localize="false"/> <h1 id="hd_id3153982"><variable id="year"><link href="text/scalc/01/func_year.xhp">YEAR</link> </variable></h1> -<paragraph role="paragraph" id="par_id3147496" xml-lang="en-US"><ahelp hid="HID_FUNC_JAHR">Returns the year as a number according to the <link href="text/scalc/01/04060102.xhp#datebase">internal calculation rules</link>.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3147496"><ahelp hid="HID_FUNC_JAHR">Returns the year as a number according to the <link href="text/scalc/01/04060102.xhp#datebase">internal calculation rules</link>.</ahelp></paragraph> <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph role="code" id="par_id3154304" xml-lang="en-US">YEAR(Number)</paragraph> -<paragraph role="paragraph" id="par_id3156013" xml-lang="en-US"> +<paragraph role="code" id="par_id3154304">YEAR(Number)</paragraph> +<paragraph role="paragraph" id="par_id3156013"> <emph>Number</emph> shows the internal date value for which the year is to be returned.</paragraph> +<note id="par_id451715611481885">YEAR() returns the integer part of the year.</note> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> -<paragraph role="paragraph" id="par_id3145668" xml-lang="en-US"> +<paragraph role="paragraph" id="par_id3145668"> <item type="input">=YEAR(1)</item> returns 1899</paragraph> -<paragraph role="paragraph" id="par_id3151168" xml-lang="en-US"> +<paragraph role="paragraph" id="par_id3151168"> <item type="input">=YEAR(2)</item> returns 1900</paragraph> -<paragraph role="paragraph" id="par_id3150115" xml-lang="en-US"> +<paragraph role="paragraph" id="par_id3150115"> <item type="input">=YEAR(33333.33)</item> returns 1991</paragraph> <paragraph role="paragraph" id="par_id141577548861101"><input>=YEAR(DATEVALUE("2010-09-28"))</input> returns 2010.</paragraph> |