diff options
| -rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03030202.xhp | 53 | ||||
| -rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03030203.xhp | 38 | ||||
| -rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03030204.xhp | 53 | ||||
| -rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03030205.xhp | 79 | ||||
| -rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03030206.xhp | 80 |
5 files changed, 160 insertions, 143 deletions
diff --git a/helpcontent2/source/text/sbasic/shared/03030202.xhp b/helpcontent2/source/text/sbasic/shared/03030202.xhp index 55256a37b0..c04c1958f2 100755 --- a/helpcontent2/source/text/sbasic/shared/03030202.xhp +++ b/helpcontent2/source/text/sbasic/shared/03030202.xhp @@ -52,38 +52,41 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03030202xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Minute Function [Runtime]</title> +<title id="tit" xml-lang="en-US">Minute Function [Runtime]</title> <filename>/text/sbasic/shared/03030202.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T13:34:29">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="minute"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3155419"><bookmark_value>Minute;function</bookmark_value></bookmark><paragraph id="hd_id3155419" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03030202.xhp" name="Minute Function [Runtime]">Minute Function [Runtime]</link></paragraph> - <paragraph role="paragraph" id="par_id3156344" l10n="U" xml-lang="en-US" oldref="2">Returns the minute of the hour that corresponds to the serial time value that is generated by the TimeSerial or the TimeValue function.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3154758" l10n="U" xml-lang="en-US" oldref="3">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3149656" l10n="U" xml-lang="en-US" oldref="4">Minute (Number)</paragraph> - <paragraph role="heading" level="2" id="hd_id3148798" l10n="U" xml-lang="en-US" oldref="5">Return value:</paragraph> - <paragraph role="paragraph" id="par_id3150449" l10n="U" xml-lang="en-US" oldref="6">Integer</paragraph> - <paragraph role="heading" level="2" id="hd_id3153193" l10n="U" xml-lang="en-US" oldref="7">Parameters:</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3153969" xml-lang="en-US" oldref="8"><emph>Number:</emph> Numeric expression that contains the serial time value that is used to return the minute value.</paragraph> - <paragraph xml-lang="en-US" oldref="9" l10n="U" role="paragraph" id="par_id3150869">This function is the opposite of the <emph>TimeSerial </emph>function. It returns the minute of the serial time value that is generated by the <emph>TimeSerial</emph> or the <emph>TimeValue </emph>function. For example, the expression:</paragraph> - <paragraph role="paragraph" id="par_id3149262" l10n="U" xml-lang="en-US" oldref="10">Print Minute(TimeSerial(12:30:41))</paragraph> - <paragraph role="paragraph" id="par_id3148576" l10n="U" xml-lang="en-US" oldref="11">returns the value 30.</paragraph> - <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> - <embed href="text/sbasic/shared/00000003.xhp#err5"/> - <paragraph role="heading" level="2" id="hd_id3150010" l10n="U" xml-lang="en-US" oldref="12">Example:</paragraph> - <paragraph role="paragraph" id="par_id3159154" l10n="U" xml-lang="en-US" oldref="13">Sub ExampleMinute</paragraph> - <paragraph role="paragraph" id="par_id3146119" l10n="U" xml-lang="en-US" oldref="14">MsgBox "The current minute is "& Minute(Now)& "."</paragraph> - <paragraph role="paragraph" id="par_id3153726" l10n="U" xml-lang="en-US" oldref="15">end sub</paragraph> - </body> +<section id="minute"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3155419"><bookmark_value>Minute function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3155419" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03030202.xhp" name="Minute Function [Runtime]">Minute Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3156344" xml-lang="en-US" l10n="U" oldref="2">Returns the minute of the hour that corresponds to the serial time value that is generated by the TimeSerial or the TimeValue function.</paragraph> +</section> +<paragraph role="heading" id="hd_id3154758" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US" l10n="U" oldref="4">Minute (Number)</paragraph> +<paragraph role="heading" id="hd_id3148798" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value:</paragraph> +<paragraph role="paragraph" id="par_id3150449" xml-lang="en-US" l10n="U" oldref="6">Integer</paragraph> +<paragraph role="heading" id="hd_id3153193" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="U" oldref="8"> +<emph>Number:</emph> Numeric expression that contains the serial time value that is used to return the minute value.</paragraph> +<paragraph role="paragraph" id="par_id3150869" xml-lang="en-US" l10n="U" oldref="9">This function is the opposite of the <emph>TimeSerial </emph>function. It returns the minute of the serial time value that is generated by the <emph>TimeSerial</emph> or the <emph>TimeValue </emph>function. For example, the expression:</paragraph> +<paragraph role="paragraph" id="par_id3149262" xml-lang="en-US" l10n="U" oldref="10">Print Minute(TimeSerial(12:30:41))</paragraph> +<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US" l10n="U" oldref="11">returns the value 30.</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<paragraph role="heading" id="hd_id3150010" xml-lang="en-US" level="2" l10n="U" oldref="12">Example:</paragraph> +<paragraph role="paragraph" id="par_id3159154" xml-lang="en-US" l10n="U" oldref="13">Sub ExampleMinute</paragraph> +<paragraph role="paragraph" id="par_id3146119" xml-lang="en-US" l10n="U" oldref="14">MsgBox "The current minute is "& Minute(Now)& "."</paragraph> +<paragraph role="paragraph" id="par_id3153726" xml-lang="en-US" l10n="U" oldref="15">end sub</paragraph> +</body> </helpdocument> diff --git a/helpcontent2/source/text/sbasic/shared/03030203.xhp b/helpcontent2/source/text/sbasic/shared/03030203.xhp index 5690673c18..715c6c2e71 100755 --- a/helpcontent2/source/text/sbasic/shared/03030203.xhp +++ b/helpcontent2/source/text/sbasic/shared/03030203.xhp @@ -52,31 +52,33 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03030203xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Now Function [Runtime]</title> +<title id="tit" xml-lang="en-US">Now Function [Runtime]</title> <filename>/text/sbasic/shared/03030203.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T13:44:47">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="now"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3149416"><bookmark_value>Now;function</bookmark_value></bookmark><paragraph id="hd_id3149416" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03030203.xhp" name="Now Function [Runtime]">Now Function [Runtime]</link></paragraph> - <paragraph xml-lang="en-US" role="paragraph" id="par_id3149670" l10n="U" oldref="2">Returns the current system date and time as a <emph>Date</emph> value.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3149456" l10n="U" xml-lang="en-US" oldref="3">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3149655" l10n="U" xml-lang="en-US" oldref="4">Now</paragraph> - <paragraph role="heading" level="2" id="hd_id3154366" l10n="U" xml-lang="en-US" oldref="5">Return value:</paragraph> - <paragraph role="paragraph" id="par_id3154909" l10n="U" xml-lang="en-US" oldref="6">Date</paragraph> - <paragraph role="heading" level="2" id="hd_id3147229" l10n="U" xml-lang="en-US" oldref="7">Example:</paragraph> - <paragraph role="paragraph" id="par_id3145172" l10n="U" xml-lang="en-US" oldref="8">Sub ExampleNow</paragraph> - <paragraph role="paragraph" id="par_id3150870" l10n="U" xml-lang="en-US" oldref="9">msgbox "It is now " & Now</paragraph> - <paragraph role="paragraph" id="par_id3145787" l10n="U" xml-lang="en-US" oldref="10">End sub</paragraph> - </body> +<section id="now"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3149416"><bookmark_value>Now function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3149416" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03030203.xhp" name="Now Function [Runtime]">Now Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3149670" xml-lang="en-US" l10n="U" oldref="2">Returns the current system date and time as a <emph>Date</emph> value.</paragraph> +</section> +<paragraph role="heading" id="hd_id3149456" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3149655" xml-lang="en-US" l10n="U" oldref="4">Now</paragraph> +<paragraph role="heading" id="hd_id3154366" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value:</paragraph> +<paragraph role="paragraph" id="par_id3154909" xml-lang="en-US" l10n="U" oldref="6">Date</paragraph> +<paragraph role="heading" id="hd_id3147229" xml-lang="en-US" level="2" l10n="U" oldref="7">Example:</paragraph> +<paragraph role="paragraph" id="par_id3145172" xml-lang="en-US" l10n="U" oldref="8">Sub ExampleNow</paragraph> +<paragraph role="paragraph" id="par_id3150870" xml-lang="en-US" l10n="U" oldref="9">msgbox "It is now " & Now</paragraph> +<paragraph role="paragraph" id="par_id3145787" xml-lang="en-US" l10n="U" oldref="10">End sub</paragraph> +</body> </helpdocument> diff --git a/helpcontent2/source/text/sbasic/shared/03030204.xhp b/helpcontent2/source/text/sbasic/shared/03030204.xhp index 1335de9477..d469aef3f5 100755 --- a/helpcontent2/source/text/sbasic/shared/03030204.xhp +++ b/helpcontent2/source/text/sbasic/shared/03030204.xhp @@ -52,38 +52,41 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03030204xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Second Function [Runtime]</title> +<title id="tit" xml-lang="en-US">Second Function [Runtime]</title> <filename>/text/sbasic/shared/03030204.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T14:18:44">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="second"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3153346"><bookmark_value>Second;function</bookmark_value></bookmark><paragraph id="hd_id3153346" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03030204.xhp" name="Second Function [Runtime]">Second Function [Runtime]</link></paragraph> - <paragraph role="paragraph" id="par_id3156023" l10n="U" xml-lang="en-US" oldref="2">Returns an integer that represents the seconds of the serial time number that is generated by the TimeSerial or the TimeValue function.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3147264" l10n="U" xml-lang="en-US" oldref="3">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3146795" l10n="U" xml-lang="en-US" oldref="4">Second (Number)</paragraph> - <paragraph role="heading" level="2" id="hd_id3150792" l10n="U" xml-lang="en-US" oldref="5">Return value:</paragraph> - <paragraph role="paragraph" id="par_id3154140" l10n="U" xml-lang="en-US" oldref="6">Integer</paragraph> - <paragraph role="heading" level="2" id="hd_id3156280" l10n="U" xml-lang="en-US" oldref="7">Parameters:</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3154124" xml-lang="en-US" oldref="8"><emph>Number:</emph> Numeric expression that contains the serial time number that is used to calculate the number of seconds.</paragraph> - <paragraph xml-lang="en-US" oldref="9" l10n="U" role="paragraph" id="par_id3125864">This function is the opposite of the <emph>TimeSerial </emph>function. It returns the seconds of a serial time value that is generated by the <emph>TimeSerial</emph> or <emph>TimeValue </emph>functions. For example, the expression:</paragraph> - <paragraph role="paragraph" id="par_id3153951" l10n="U" xml-lang="en-US" oldref="10">Print Second(TimeSerial(12,30,41))</paragraph> - <paragraph role="paragraph" id="par_id3151117" l10n="U" xml-lang="en-US" oldref="11">returns the value 41.</paragraph> - <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> - <embed href="text/sbasic/shared/00000003.xhp#err5"/> - <paragraph role="heading" level="2" id="hd_id3147426" l10n="U" xml-lang="en-US" oldref="12">Example:</paragraph> - <paragraph role="paragraph" id="par_id3154012" l10n="U" xml-lang="en-US" oldref="13">Sub ExampleSecond</paragraph> - <paragraph role="paragraph" id="par_id3156441" l10n="U" xml-lang="en-US" oldref="14">MsgBox "The exact second of the current time is "& Second( Now )</paragraph> - <paragraph role="paragraph" id="par_id3151112" l10n="U" xml-lang="en-US" oldref="15">End sub</paragraph> - </body> +<section id="second"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3153346"><bookmark_value>Second function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3153346" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03030204.xhp" name="Second Function [Runtime]">Second Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3156023" xml-lang="en-US" l10n="U" oldref="2">Returns an integer that represents the seconds of the serial time number that is generated by the TimeSerial or the TimeValue function.</paragraph> +</section> +<paragraph role="heading" id="hd_id3147264" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3146795" xml-lang="en-US" l10n="U" oldref="4">Second (Number)</paragraph> +<paragraph role="heading" id="hd_id3150792" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value:</paragraph> +<paragraph role="paragraph" id="par_id3154140" xml-lang="en-US" l10n="U" oldref="6">Integer</paragraph> +<paragraph role="heading" id="hd_id3156280" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3154124" xml-lang="en-US" l10n="U" oldref="8"> +<emph>Number:</emph> Numeric expression that contains the serial time number that is used to calculate the number of seconds.</paragraph> +<paragraph role="paragraph" id="par_id3125864" xml-lang="en-US" l10n="U" oldref="9">This function is the opposite of the <emph>TimeSerial </emph>function. It returns the seconds of a serial time value that is generated by the <emph>TimeSerial</emph> or <emph>TimeValue </emph>functions. For example, the expression:</paragraph> +<paragraph role="paragraph" id="par_id3153951" xml-lang="en-US" l10n="U" oldref="10">Print Second(TimeSerial(12,30,41))</paragraph> +<paragraph role="paragraph" id="par_id3151117" xml-lang="en-US" l10n="U" oldref="11">returns the value 41.</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<paragraph role="heading" id="hd_id3147426" xml-lang="en-US" level="2" l10n="U" oldref="12">Example:</paragraph> +<paragraph role="paragraph" id="par_id3154012" xml-lang="en-US" l10n="U" oldref="13">Sub ExampleSecond</paragraph> +<paragraph role="paragraph" id="par_id3156441" xml-lang="en-US" l10n="U" oldref="14">MsgBox "The exact second of the current time is "& Second( Now )</paragraph> +<paragraph role="paragraph" id="par_id3151112" xml-lang="en-US" l10n="U" oldref="15">End sub</paragraph> +</body> </helpdocument> diff --git a/helpcontent2/source/text/sbasic/shared/03030205.xhp b/helpcontent2/source/text/sbasic/shared/03030205.xhp index f3114eb0aa..7626d07c27 100755 --- a/helpcontent2/source/text/sbasic/shared/03030205.xhp +++ b/helpcontent2/source/text/sbasic/shared/03030205.xhp @@ -52,49 +52,56 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03030205xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">TimeSerial Function [Runtime]</title> +<title id="tit" xml-lang="en-US">TimeSerial Function [Runtime]</title> <filename>/text/sbasic/shared/03030205.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T14:40:09">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="timeserial"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3143271"><bookmark_value>TimeSerial;function</bookmark_value></bookmark><paragraph id="hd_id3143271" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03030205.xhp" name="TimeSerial Function [Runtime]">TimeSerial Function [Runtime]</link></paragraph> - <paragraph role="paragraph" id="par_id3156344" l10n="U" xml-lang="en-US" oldref="2">Calculates a serial time value for the specified hour, minute, and second parameters that are passed as numeric value. You can then use this value to calculate the difference between times.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3146794" l10n="U" xml-lang="en-US" oldref="4">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3150792" l10n="U" xml-lang="en-US" oldref="5">TimeSerial (hour, minute, second)</paragraph> - <paragraph role="heading" level="2" id="hd_id3148797" l10n="U" xml-lang="en-US" oldref="6">Return value:</paragraph> - <paragraph role="paragraph" id="par_id3154908" l10n="U" xml-lang="en-US" oldref="7">Date</paragraph> - <paragraph role="heading" level="2" id="hd_id3154124" l10n="U" xml-lang="en-US" oldref="8">Parameters:</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3153193" xml-lang="en-US" oldref="9"><emph>hour:</emph> Any integer expression that indicates the hour of the time that is used to determine the serial time value. Valid values: 0-23.</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3159252" xml-lang="en-US" oldref="10"><emph>minute:</emph> Any integer expression that indicates the minute of the time that is used to determine the serial time value. In general, use values between 0 and 59. However, you can also use values that lie outside of this range, where the number of minutes influence the hour value.</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3161831" xml-lang="en-US" oldref="11"><emph>second:</emph> Any integer expression that indicates the second of the time that is used to determine the serial time value. In general, you can use values between 0 and 59. However, you can also use values that lie outside of this range, where the number seconds influences the minute value.</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3155854" xml-lang="en-US" oldref="12"><emph>Examples:</emph></paragraph> - <paragraph role="paragraph" id="par_id3153952" l10n="U" xml-lang="en-US" oldref="13">12, -5, 45 corresponds to 11, 55, 45</paragraph> - <paragraph role="paragraph" id="par_id3147349" l10n="U" xml-lang="en-US" oldref="14">12, 61, 45 corresponds to 13, 2, 45</paragraph> - <paragraph role="paragraph" id="par_id3147426" l10n="U" xml-lang="en-US" oldref="15">12, 20, -2 corresponds to 12, 19, 58</paragraph> - <paragraph role="paragraph" id="par_id3153365" l10n="U" xml-lang="en-US" oldref="16">12, 20, 63 corresponds to 12, 21, 4</paragraph> - <paragraph role="paragraph" id="par_id3146985" l10n="U" xml-lang="en-US" oldref="17">You can use the TimeSerial function to convert any time into a single value that you can use to calculate time differences.</paragraph> - <paragraph role="paragraph" id="par_id3155308" l10n="U" xml-lang="en-US" oldref="18">The TimeSerial function returns the type Variant with VarType 7 (Date). This value is stored internally as a double-precision number between 0 and 0.9999999999. As opposed to the DateSerial or DateValue function, where the serial date values are calculated as days relative to a fixed date, you can calculate with values returned by the TimeSerial function, but you cannot evaluate them.</paragraph> - <paragraph role="paragraph" id="par_id3149482" l10n="U" xml-lang="en-US" oldref="19">In the TimeValue function, you can pass a string as a parameter containing the time. For the TimeSerial function, however, you can pass the individual parameters (hour, minute, second) as separate numeric expressions.</paragraph> - <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> - <embed href="text/sbasic/shared/00000003.xhp#err5"/> - <paragraph role="heading" level="2" id="hd_id3154790" l10n="U" xml-lang="en-US" oldref="20">Example:</paragraph> - <paragraph role="paragraph" id="par_id3145252" l10n="U" xml-lang="en-US" oldref="21">Sub ExampleTimeSerial</paragraph> - <paragraph role="paragraph" id="par_id3153157" l10n="U" xml-lang="en-US" oldref="22">Dim dDate As Double, sDate As String</paragraph> - <paragraph role="paragraph" id="par_id3156286" l10n="U" xml-lang="en-US" oldref="23">dDate = TimeSerial(8,30,15)</paragraph> - <paragraph role="paragraph" id="par_id3148456" l10n="U" xml-lang="en-US" oldref="24">sDate = TimeSerial(8,30,15)</paragraph> - <paragraph role="paragraph" id="par_id3155600" l10n="U" xml-lang="en-US" oldref="25">MsgBox dDate,64,"Time as a number"</paragraph> - <paragraph role="paragraph" id="par_id3153417" l10n="U" xml-lang="en-US" oldref="26">MsgBox sDate,64,"Formatted time"</paragraph> - <paragraph role="paragraph" id="par_id3153836" l10n="U" xml-lang="en-US" oldref="27">End Sub</paragraph> - </body> +<section id="timeserial"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3143271"><bookmark_value>TimeSerial function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3143271" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03030205.xhp" name="TimeSerial Function [Runtime]">TimeSerial Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3156344" xml-lang="en-US" l10n="U" oldref="2">Calculates a serial time value for the specified hour, minute, and second parameters that are passed as numeric value. You can then use this value to calculate the difference between times.</paragraph> +</section> +<paragraph role="heading" id="hd_id3146794" xml-lang="en-US" level="2" l10n="U" oldref="4">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3150792" xml-lang="en-US" l10n="U" oldref="5">TimeSerial (hour, minute, second)</paragraph> +<paragraph role="heading" id="hd_id3148797" xml-lang="en-US" level="2" l10n="U" oldref="6">Return value:</paragraph> +<paragraph role="paragraph" id="par_id3154908" xml-lang="en-US" l10n="U" oldref="7">Date</paragraph> +<paragraph role="heading" id="hd_id3154124" xml-lang="en-US" level="2" l10n="U" oldref="8">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3153193" xml-lang="en-US" l10n="U" oldref="9"> +<emph>hour:</emph> Any integer expression that indicates the hour of the time that is used to determine the serial time value. Valid values: 0-23.</paragraph> +<paragraph role="paragraph" id="par_id3159252" xml-lang="en-US" l10n="U" oldref="10"> +<emph>minute:</emph> Any integer expression that indicates the minute of the time that is used to determine the serial time value. In general, use values between 0 and 59. However, you can also use values that lie outside of this range, where the number of minutes influence the hour value.</paragraph> +<paragraph role="paragraph" id="par_id3161831" xml-lang="en-US" l10n="U" oldref="11"> +<emph>second:</emph> Any integer expression that indicates the second of the time that is used to determine the serial time value. In general, you can use values between 0 and 59. However, you can also use values that lie outside of this range, where the number seconds influences the minute value.</paragraph> +<paragraph role="paragraph" id="par_id3155854" xml-lang="en-US" l10n="U" oldref="12"> +<emph>Examples:</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3153952" xml-lang="en-US" l10n="U" oldref="13">12, -5, 45 corresponds to 11, 55, 45</paragraph> +<paragraph role="paragraph" id="par_id3147349" xml-lang="en-US" l10n="U" oldref="14">12, 61, 45 corresponds to 13, 2, 45</paragraph> +<paragraph role="paragraph" id="par_id3147426" xml-lang="en-US" l10n="U" oldref="15">12, 20, -2 corresponds to 12, 19, 58</paragraph> +<paragraph role="paragraph" id="par_id3153365" xml-lang="en-US" l10n="U" oldref="16">12, 20, 63 corresponds to 12, 21, 4</paragraph> +<paragraph role="paragraph" id="par_id3146985" xml-lang="en-US" l10n="U" oldref="17">You can use the TimeSerial function to convert any time into a single value that you can use to calculate time differences.</paragraph> +<paragraph role="paragraph" id="par_id3155308" xml-lang="en-US" l10n="U" oldref="18">The TimeSerial function returns the type Variant with VarType 7 (Date). This value is stored internally as a double-precision number between 0 and 0.9999999999. As opposed to the DateSerial or DateValue function, where the serial date values are calculated as days relative to a fixed date, you can calculate with values returned by the TimeSerial function, but you cannot evaluate them.</paragraph> +<paragraph role="paragraph" id="par_id3149482" xml-lang="en-US" l10n="U" oldref="19">In the TimeValue function, you can pass a string as a parameter containing the time. For the TimeSerial function, however, you can pass the individual parameters (hour, minute, second) as separate numeric expressions.</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<paragraph role="heading" id="hd_id3154790" xml-lang="en-US" level="2" l10n="U" oldref="20">Example:</paragraph> +<paragraph role="paragraph" id="par_id3145252" xml-lang="en-US" l10n="U" oldref="21">Sub ExampleTimeSerial</paragraph> +<paragraph role="paragraph" id="par_id3153157" xml-lang="en-US" l10n="U" oldref="22">Dim dDate As Double, sDate As String</paragraph> +<paragraph role="paragraph" id="par_id3156286" xml-lang="en-US" l10n="U" oldref="23">dDate = TimeSerial(8,30,15)</paragraph> +<paragraph role="paragraph" id="par_id3148456" xml-lang="en-US" l10n="U" oldref="24">sDate = TimeSerial(8,30,15)</paragraph> +<paragraph role="paragraph" id="par_id3155600" xml-lang="en-US" l10n="U" oldref="25">MsgBox dDate,64,"Time as a number"</paragraph> +<paragraph role="paragraph" id="par_id3153417" xml-lang="en-US" l10n="U" oldref="26">MsgBox sDate,64,"Formatted time"</paragraph> +<paragraph role="paragraph" id="par_id3153836" xml-lang="en-US" l10n="U" oldref="27">End Sub</paragraph> +</body> </helpdocument> diff --git a/helpcontent2/source/text/sbasic/shared/03030206.xhp b/helpcontent2/source/text/sbasic/shared/03030206.xhp index 971ad03f97..3701f9a1f8 100755 --- a/helpcontent2/source/text/sbasic/shared/03030206.xhp +++ b/helpcontent2/source/text/sbasic/shared/03030206.xhp @@ -52,52 +52,54 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03030206xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">TimeValue Function [Runtime]</title> +<title id="tit" xml-lang="en-US">TimeValue Function [Runtime]</title> <filename>/text/sbasic/shared/03030206.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T14:40:35">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="timevalue"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3149670"><bookmark_value>TimeValue;function</bookmark_value></bookmark><paragraph id="hd_id3149670" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03030206.xhp" name="TimeValue Function [Runtime]">TimeValue Function [Runtime]</link></paragraph> - <paragraph role="paragraph" id="par_id3153361" l10n="U" xml-lang="en-US" oldref="2">Calculates a serial time value from the specified hour, minute, and second - parameters passed as strings - that represents the time in a single numeric value. This value can be used to calculate the difference between times.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3154138" l10n="U" xml-lang="en-US" oldref="3">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3156282" l10n="U" xml-lang="en-US" oldref="4">TimeValue (Text As String)</paragraph> - <paragraph role="heading" level="2" id="hd_id3153969" l10n="U" xml-lang="en-US" oldref="5">Return value:</paragraph> - <paragraph role="paragraph" id="par_id3156424" l10n="U" xml-lang="en-US" oldref="6">Date</paragraph> - <paragraph role="heading" level="2" id="hd_id3145172" l10n="U" xml-lang="en-US" oldref="7">Parameters:</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3145786" xml-lang="en-US" oldref="8"><emph>Text:</emph> Any string expression that contains the time that you want to calculate in the format "HH:MM:SS".</paragraph> - <paragraph role="paragraph" id="par_id3152578" l10n="U" xml-lang="en-US" oldref="9">Use the TimeValue function to convert any time into a single value, so that you can calculate time differences.</paragraph> - <paragraph role="paragraph" id="par_id3163710" l10n="U" xml-lang="en-US" oldref="10">This TimeValue function returns the type Variant with VarType 7 (Date), and stores this value internally as a double-precision number between 0 and 0.9999999999.</paragraph> - <paragraph role="paragraph" id="par_id3151117" l10n="U" xml-lang="en-US" oldref="11">As opposed to the DateSerial or the DateValue function, where serial date values result in days relative to a fixed date, you can calculate with the values that are returned by the TimeValue function, but you cannot evaluate them.</paragraph> - <paragraph role="paragraph" id="par_id3147426" l10n="U" xml-lang="en-US" oldref="12">In the TimeSerial function, you can pass individual parameters (hour, minute, second) as separate numeric expressions. For the TimeValue function, however, you can pass a string as a parameter containing the time.</paragraph> - <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> - <embed href="text/sbasic/shared/00000003.xhp#err5"/> - <embed href="text/sbasic/shared/00000003.xhp#err13"/> - <paragraph role="heading" level="2" id="hd_id3145271" l10n="U" xml-lang="en-US" oldref="13">Example:</paragraph> - <paragraph role="paragraph" id="par_id3152597" l10n="U" xml-lang="en-US" oldref="30">Sub ExampleTimerValue</paragraph> - <paragraph role="paragraph" id="par_id3147348" l10n="U" xml-lang="en-US" oldref="31">Dim daDT as Date</paragraph> - <paragraph role="paragraph" id="par_id3148576" l10n="U" xml-lang="en-US" oldref="32">Dim a1, b1, c1, a2, b2, c2 as String</paragraph> - <paragraph role="paragraph" id="par_id3149378" l10n="U" xml-lang="en-US" oldref="33">a1 = "start time"</paragraph> - <paragraph role="paragraph" id="par_id3145800" l10n="U" xml-lang="en-US" oldref="34">b1 = "end time"</paragraph> - <paragraph role="paragraph" id="par_id3151074" l10n="U" xml-lang="en-US" oldref="35">c1 = "total time"</paragraph> - - <paragraph role="paragraph" id="par_id3154492" l10n="U" xml-lang="en-US" oldref="37">a2 = "8:34"</paragraph> - <paragraph role="paragraph" id="par_id3155602" l10n="U" xml-lang="en-US" oldref="38">b2 = "18:12"</paragraph> - <paragraph role="paragraph" id="par_id3150715" l10n="U" xml-lang="en-US" oldref="39">daDT = TimeValue(b2) - TimeValue(a2)</paragraph> - <paragraph role="paragraph" id="par_id3153838" l10n="U" xml-lang="en-US" oldref="40">c2 = a1 & ": " & a2 & chr(13)</paragraph> - <paragraph role="paragraph" id="par_id3150749" l10n="U" xml-lang="en-US" oldref="41">c2 = c2 & b1 & ": " & b2 & chr(13)</paragraph> - <paragraph role="paragraph" id="par_id3154755" l10n="U" xml-lang="en-US" oldref="42">c2 = c2 & c1 & ": " & trim(Str(Hour(daDT))) & ":" & trim(Str(Minute(daDT))) & ":" & trim(Str(Second(daDT)))</paragraph> - <paragraph role="paragraph" id="par_id3153714" l10n="U" xml-lang="en-US" oldref="43">Msgbox c2</paragraph> - <paragraph role="paragraph" id="par_id3155767" l10n="U" xml-lang="en-US" oldref="44">end sub</paragraph> - </body> +<section id="timevalue"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3149670"><bookmark_value>TimeValue function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3149670" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03030206.xhp" name="TimeValue Function [Runtime]">TimeValue Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3153361" xml-lang="en-US" l10n="U" oldref="2">Calculates a serial time value from the specified hour, minute, and second - parameters passed as strings - that represents the time in a single numeric value. This value can be used to calculate the difference between times.</paragraph> +</section> +<paragraph role="heading" id="hd_id3154138" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3156282" xml-lang="en-US" l10n="U" oldref="4">TimeValue (Text As String)</paragraph> +<paragraph role="heading" id="hd_id3153969" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value:</paragraph> +<paragraph role="paragraph" id="par_id3156424" xml-lang="en-US" l10n="U" oldref="6">Date</paragraph> +<paragraph role="heading" id="hd_id3145172" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3145786" xml-lang="en-US" l10n="U" oldref="8"> +<emph>Text:</emph> Any string expression that contains the time that you want to calculate in the format "HH:MM:SS".</paragraph> +<paragraph role="paragraph" id="par_id3152578" xml-lang="en-US" l10n="U" oldref="9">Use the TimeValue function to convert any time into a single value, so that you can calculate time differences.</paragraph> +<paragraph role="paragraph" id="par_id3163710" xml-lang="en-US" l10n="U" oldref="10">This TimeValue function returns the type Variant with VarType 7 (Date), and stores this value internally as a double-precision number between 0 and 0.9999999999.</paragraph> +<paragraph role="paragraph" id="par_id3151117" xml-lang="en-US" l10n="U" oldref="11">As opposed to the DateSerial or the DateValue function, where serial date values result in days relative to a fixed date, you can calculate with the values that are returned by the TimeValue function, but you cannot evaluate them.</paragraph> +<paragraph role="paragraph" id="par_id3147426" xml-lang="en-US" l10n="U" oldref="12">In the TimeSerial function, you can pass individual parameters (hour, minute, second) as separate numeric expressions. For the TimeValue function, however, you can pass a string as a parameter containing the time.</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<embed href="text/sbasic/shared/00000003.xhp#err13"/> +<paragraph role="heading" id="hd_id3145271" xml-lang="en-US" level="2" l10n="U" oldref="13">Example:</paragraph> +<paragraph role="paragraph" id="par_id3152597" xml-lang="en-US" l10n="U" oldref="30">Sub ExampleTimerValue</paragraph> +<paragraph role="paragraph" id="par_id3147348" xml-lang="en-US" l10n="U" oldref="31">Dim daDT as Date</paragraph> +<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US" l10n="U" oldref="32">Dim a1, b1, c1, a2, b2, c2 as String</paragraph> +<paragraph role="paragraph" id="par_id3149378" xml-lang="en-US" l10n="U" oldref="33">a1 = "start time"</paragraph> +<paragraph role="paragraph" id="par_id3145800" xml-lang="en-US" l10n="U" oldref="34">b1 = "end time"</paragraph> +<paragraph role="paragraph" id="par_id3151074" xml-lang="en-US" l10n="U" oldref="35">c1 = "total time"</paragraph> +<paragraph role="paragraph" id="par_id3154492" xml-lang="en-US" l10n="U" oldref="37">a2 = "8:34"</paragraph> +<paragraph role="paragraph" id="par_id3155602" xml-lang="en-US" l10n="U" oldref="38">b2 = "18:12"</paragraph> +<paragraph role="paragraph" id="par_id3150715" xml-lang="en-US" l10n="U" oldref="39">daDT = TimeValue(b2) - TimeValue(a2)</paragraph> +<paragraph role="paragraph" id="par_id3153838" xml-lang="en-US" l10n="U" oldref="40">c2 = a1 & ": " & a2 & chr(13)</paragraph> +<paragraph role="paragraph" id="par_id3150749" xml-lang="en-US" l10n="U" oldref="41">c2 = c2 & b1 & ": " & b2 & chr(13)</paragraph> +<paragraph role="paragraph" id="par_id3154755" xml-lang="en-US" l10n="U" oldref="42">c2 = c2 & c1 & ": " & trim(Str(Hour(daDT))) & ":" & trim(Str(Minute(daDT))) & ":" & trim(Str(Second(daDT)))</paragraph> +<paragraph role="paragraph" id="par_id3153714" xml-lang="en-US" l10n="U" oldref="43">Msgbox c2</paragraph> +<paragraph role="paragraph" id="par_id3155767" xml-lang="en-US" l10n="U" oldref="44">end sub</paragraph> +</body> </helpdocument> |