diff options
| author | Dennis Roczek <dennisroczek@libreoffice.org> | 2015-09-26 16:50:20 +0200 |
|---|---|---|
| committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2015-09-28 08:14:00 +0000 |
| commit | dd688ed491a98962477406ac75b6dc149b90f5ed (patch) | |
| tree | d5f1455c898dc1146af5625c7787ae8e175e4a5b /source | |
| parent | cbd8b8768afb8dbb6c8a2d5fc35ba0fdcd4e5768 (diff) | |
TIMEVALUE returns 0 when 24:00 is the value, not 1
Change-Id: Ifd1e15ef34129c0a2fa557a83b342d7554f60a58
Reviewed-on: https://gerrit.libreoffice.org/18892
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/func_timevalue.xhp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/func_timevalue.xhp b/source/text/scalc/01/func_timevalue.xhp index 7f2f8d63d0..eb23135c07 100644 --- a/source/text/scalc/01/func_timevalue.xhp +++ b/source/text/scalc/01/func_timevalue.xhp @@ -37,6 +37,6 @@ <paragraph id="par_id3152556" role="paragraph" xml-lang="en-US"><emph>Text</emph> is a valid time expression and must be entered in quotation marks.</paragraph> <paragraph id="hd_id3146815" role="heading" xml-lang="en-US" level="3">Examples</paragraph> <paragraph id="par_id3146829" role="paragraph" xml-lang="en-US"><item type="input">=TIMEVALUE("4PM")</item> returns 0.67. When formatting in time format HH:MM:SS, you then get 16:00:00.</paragraph> -<paragraph id="par_id3153632" role="paragraph" xml-lang="en-US"><item type="input">=TIMEVALUE("24:00")</item> returns 1. If you use the HH:MM:SS time format, the value is 00:00:00.</paragraph> +<paragraph id="par_id3153632" role="paragraph" xml-lang="en-US"><item type="input">=TIMEVALUE("24:00")</item> returns 0. If you use the HH:MM:SS time format, the value is 00:00:00.</paragraph> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> |