diff options
| author | Frank Peters <fpe@openoffice.org> | 2004-08-18 09:59:46 +0000 |
|---|---|---|
| committer | Frank Peters <fpe@openoffice.org> | 2004-08-18 09:59:46 +0000 |
| commit | 4f48bcc7937fbc586af7720d4225768ee6913e2a (patch) | |
| tree | 431c32101c9b8349fe8f420615df796296d69a90 /helpcontent2/source/text/scalc/01/func_timevalue.xhp | |
#i33146# Initial checkin
Diffstat (limited to 'helpcontent2/source/text/scalc/01/func_timevalue.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/func_timevalue.xhp | 84 |
1 files changed, 84 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/01/func_timevalue.xhp b/helpcontent2/source/text/scalc/01/func_timevalue.xhp new file mode 100644 index 0000000000..2c7f9f970f --- /dev/null +++ b/helpcontent2/source/text/scalc/01/func_timevalue.xhp @@ -0,0 +1,84 @@ +<?xml version="1.0" encoding="UTF-8"?>
+<!--*********************************************************************** + * + * The Contents of this file are made available subject to the terms of + * either of the following licenses + * + * - GNU Lesser General Public License Version 2.1 + * - Sun Industry Standards Source License Version 1.1 + * + * Sun Microsystems Inc., October, 2000 + * + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2000 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. + * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA + * + * + * Sun Industry Standards Source License Version 1.1 + * ================================================= + * The contents of this file are subject to the Sun Industry Standards + * Source License Version 1.1 (the "License"); You may not use this file + * except in compliance with the License. You may obtain a copy of the + * License at http://www.openoffice.org/license.html. + * + * Software provided under this License is provided on an "AS IS" basis, + * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, + * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS, + * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. + * See the License for the specific provisions governing your rights and + * obligations concerning the Software. + * + * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. + * + * Copyright: 2000 by Sun Microsystems, Inc. + * + * All Rights Reserved. + * + * Contributor(s): _______________________________________ + * + * + ************************************************************************-->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc01func_timevaluexml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">TIMEVALUE </title>
+<filename>text/scalc/01/func_timevalue.xhp</filename>
+</topic>
+<history>
+<created date="2004-05-27T16:47:35"/>
+<lastedited date="2004-07-20T14:24:37"/>
+</history>
+</meta>
+<body> +<bookmark xml-lang="en-US" branch="index" id="bm_id3146755"><bookmark_value>TIMEVALUE function</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ZEITWERT" id="bm_id3146767" localize="false"/>
+<paragraph role="heading" id="hd_id3146755" xml-lang="en-US" level="2" l10n="U" oldref="160"><variable id="timevalue"><link href="text/scalc/01/func_timevalue.xhp">TIMEVALUE</link> +</variable></paragraph>
+<paragraph role="paragraph" id="par_id3148502" xml-lang="en-US" l10n="U" oldref="161"><ahelp hid="HID_FUNC_ZEITWERT">TIMEVALUE returns the internal time number from a text enclosed by quotes and which may show a possible time entry format.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150794" xml-lang="en-US" l10n="U" oldref="162">The internal number indicated as a decimal is the result of the date system used under $[officename] to calculate date entries.</paragraph>
+<paragraph role="heading" id="hd_id3150810" xml-lang="en-US" level="3" l10n="U" oldref="163">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3150823" xml-lang="en-US" l10n="U" oldref="164">TIMEVALUE("Text")</paragraph>
+<paragraph role="paragraph" id="par_id3152556" xml-lang="en-US" l10n="U" oldref="165">
+<emph>Text</emph> is a valid time expression and must be entered in quotation marks.</paragraph>
+<paragraph role="heading" id="hd_id3146815" xml-lang="en-US" level="3" l10n="U" oldref="166">Examples</paragraph>
+<paragraph role="paragraph" id="par_id3146829" xml-lang="en-US" l10n="U" oldref="167">TIMEVALUE("4PM") returns 0.67. When formatting in time format HH:MM:SS, you then get 16:00:00.</paragraph>
+<paragraph role="paragraph" id="par_id3153632" xml-lang="en-US" l10n="U" oldref="168">TIMEVALUE("24:00") returns 1. If you use the HH:MM:SS time format, the value is 00:00:00.</paragraph>
+</body>
+</helpdocument>
|