fdo#36057 time format using [] is needed to show hours non-modulo 24

1 files changed, 73 insertions, 0 deletions

diff --git a/helpcontent2/source/text/shared/01/05020301.xhp b/helpcontent2/source/text/shared/01/05020301.xhp
index d89091ae99..dca431ae4a 100644
--- a/helpcontent2/source/text/shared/01/05020301.xhp
+++ b/helpcontent2/source/text/shared/01/05020301.xhp
@@ -902,6 +902,79 @@
 </tablerow>
 </table>
 
+<paragraph role="paragraph" id="par_id3757982" xml-lang="en-US" l10n="U">The display of the hour, minute, and second components of the time is capped at the maximal number of hours in a day (or 12 hour period), minutes in an hour, or seconds in a minute.  To suppress this behavior use square brackets, [ ], as illustrated in the following table.</paragraph>
+<paragraph role="paragraph" id="par_id3157980" xml-lang="en-US" l10n="U">Display of the value 1 day, 1 hour, 25 minutes, 9 seconds</paragraph>
+<table id="tbl_id3154831">
+<tablerow>
+<tablecell>
+<paragraph role="tablehead" id="par_id3757983" xml-lang="en-US" l10n="U">Format Code</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablehead" id="par_id3757984" xml-lang="en-US" l10n="U">Output Displayed</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablehead" id="par_id3757985" xml-lang="en-US" l10n="U"></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablehead" id="par_id3757986" xml-lang="en-US" l10n="U">Format Code</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablehead" id="par_id3757987" xml-lang="en-US" l10n="U">Output Displayed</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph role="code" id="par_id3757988" xml-lang="en-US" l10n="U">HH:MM:SS</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3757989" xml-lang="en-US" l10n="U">01:25:09</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3757990" xml-lang="en-US" l10n="U"></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="code" id="par_id3757991" xml-lang="en-US" l10n="U">[HH]:MM:SS</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3757992" xml-lang="en-US" l10n="U">25:25:09</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph role="code" id="par_id3757993" xml-lang="en-US" l10n="U">MM:SS</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3757994" xml-lang="en-US" l10n="U">25:09</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3757995" xml-lang="en-US" l10n="U"></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="code" id="par_id3757996" xml-lang="en-US" l10n="U">[MM]:SS</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3757997" xml-lang="en-US" l10n="U">1525:09</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph role="code" id="par_id3757998" xml-lang="en-US" l10n="U">SS</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3757999" xml-lang="en-US" l10n="U">09</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3758000" xml-lang="en-US" l10n="U"></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="code" id="par_id3758001" xml-lang="en-US" l10n="U">[SS]</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3758002" xml-lang="en-US" l10n="U">91509</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
 <paragraph role="note" id="par_id3156039" xml-lang="en-US" l10n="U" oldref="77">To display seconds as fractions, add the decimal delimiter to your number format code. For example, enter <emph>hh:mm:ss.00</emph> to display the time as "01:02:03.45".<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph>
 <paragraph role="paragraph" id="par_id3148649" xml-lang="en-US" l10n="U" oldref="102">If a time is entered in the form 02:03.45 or 01:02:03.45 or 25:01:02, the following formats are assigned if no other time format has been specified: MM:SS.00 or [HH]:MM:SS.00 or [HH]:MM:SS<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph>
 <paragraph role="heading" id="hd_id3158404" xml-lang="en-US" level="2" l10n="U" oldref="169">Displaying Numbers Using Native Characters</paragraph>