From 05e4e6345e7503b162356cfcff36a8787a34e05f Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Tue, 7 Jun 2011 22:10:44 +0200 Subject: fdo#36057 time format using [] is needed to show hours non-modulo 24 --- helpcontent2/source/text/shared/01/05020301.xhp | 73 +++++++++++++++++++++++++ 1 file changed, 73 insertions(+) (limited to 'helpcontent2/source/text/shared/01') 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 @@ +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. +Display of the value 1 day, 1 hour, 25 minutes, 9 seconds + + + +Format Code + + +Output Displayed + + + + + +Format Code + + +Output Displayed + + + + +HH:MM:SS + + +01:25:09 + + + + + +[HH]:MM:SS + + +25:25:09 + + + + +MM:SS + + +25:09 + + + + + +[MM]:SS + + +1525:09 + + + + +SS + + +09 + + + + + +[SS] + + +91509 + + +
+ To display seconds as fractions, add the decimal delimiter to your number format code. For example, enter hh:mm:ss.00 to display the time as "01:02:03.45".Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc. 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:SSTranslators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc. Displaying Numbers Using Native Characters -- cgit