diff options
| author | Rüdiger Timm <rt@openoffice.org> | 2004-11-26 15:28:20 +0000 |
|---|---|---|
| committer | Rüdiger Timm <rt@openoffice.org> | 2004-11-26 15:28:20 +0000 |
| commit | b1e463afa1861f53bf1730eb04498636fb0419f6 (patch) | |
| tree | f867bf3ff82ab6e9f4ed609a3e0cebb372cc3aec /helpcontent2/source/text/scalc/guide/calc_date.xhp | |
| parent | 1ecb362392aff030d2e1cb7aff1edc591bd4d69d (diff) | |
INTEGRATION: CWS helpcontentbeta (1.1.2); FILE MERGED
2004/10/06 14:55:24 fpe 1.1.2.2: Regular Update
2004/09/16 11:46:25 fpe 1.1.2.1: Regular Update
Diffstat (limited to 'helpcontent2/source/text/scalc/guide/calc_date.xhp')
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/calc_date.xhp | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/helpcontent2/source/text/scalc/guide/calc_date.xhp b/helpcontent2/source/text/scalc/guide/calc_date.xhp index 143f1517f2..d08bf69e42 100755 --- a/helpcontent2/source/text/scalc/guide/calc_date.xhp +++ b/helpcontent2/source/text/scalc/guide/calc_date.xhp @@ -56,24 +56,24 @@ <helpdocument version="1.0"> <meta> -<topic id="textscalcguidecalc_datexml" indexer="include" status="DEPRECATED"> +<topic id="textscalcguidecalc_datexml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Calculating With Dates and Times</title> <filename>/text/scalc/guide/calc_date.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-06-08T13:27:39">FPE: Screenshot deleted</lastedited> +<lastedited date="2004-09-27T11:56:50">FPE: Screenshot deleted +YJ: checked</lastedited> </history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3146120"><bookmark_value>dates; in cells</bookmark_value> -<bookmark_value>time; in cells</bookmark_value> -<bookmark_value>cells; time formats</bookmark_value> -<bookmark_value>cells; date formats</bookmark_value> +<bookmark_value>times; in cells</bookmark_value> +<bookmark_value>cells;date and time formats</bookmark_value> </bookmark> <paragraph role="heading" id="hd_id3146120" xml-lang="en-US" level="1" l10n="U" oldref="11"><variable id="calc_date"><link href="text/scalc/guide/calc_date.xhp" name="Calculating With Dates and Times">Calculating With Dates and Times</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3154320" xml-lang="en-US" l10n="U" oldref="12">In $[officename] Calc, you can perform calculations with dates and times, since they are both taken from the internal clock of your computer. As an example, to find out exactly how old you are in seconds or hours, follow these steps:</paragraph> +<paragraph role="paragraph" id="par_id3154320" xml-lang="en-US" l10n="CHG" oldref="12">In $[officename] Calc, you can perform calculations with current date and time values. As an example, to find out exactly how old you are in seconds or hours, follow the following steps:</paragraph> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3150750" xml-lang="en-US" l10n="U" oldref="13">In a spreadsheet, enter your birthday in cell A1.</paragraph> @@ -82,7 +82,7 @@ <paragraph role="listitem" id="par_id3145642" xml-lang="en-US" l10n="U" oldref="14">Enter the following formula in cell A3: =NOW()-A1</paragraph> </listitem> <listitem> -<paragraph role="listitem" id="par_id3149020" xml-lang="en-US" l10n="U" oldref="52">After pressing the Enter key you will see the result in date format. Since the result should show the difference between two dates as a number of days, you must format cell A3 as a number.</paragraph> +<paragraph role="listitem" id="par_id3149020" xml-lang="en-US" l10n="U" oldref="52">After pressing the <item type="keycode">Enter</item> key you will see the result in date format. Since the result should show the difference between two dates as a number of days, you must format cell A3 as a number.</paragraph> </listitem> <listitem> <paragraph role="listitem" id="par_id3155335" xml-lang="en-US" l10n="U" oldref="53">Place the cursor in cell A3, right-click to open a context menu and choose <emph>Format Cells</emph>.</paragraph> @@ -94,12 +94,12 @@ <paragraph role="listitem" id="par_id3147001" xml-lang="en-US" l10n="U" oldref="15">The number of days between today's date and the specified date is displayed in cell A3.</paragraph> </listitem> <listitem> -<paragraph role="listitem" id="par_id3150304" xml-lang="en-US" l10n="U" oldref="16">Experiment with some additional formulas: in A4 enter =A3*24 to calculate the hours, in A5 enter =A4*60 for the minutes, and in A6 enter =A5*60 for seconds. Press the Enter key after each formula.</paragraph> +<paragraph role="listitem" id="par_id3150304" xml-lang="en-US" l10n="U" oldref="16">Experiment with some additional formulas: in A4 enter =A3*24 to calculate the hours, in A5 enter =A4*60 for the minutes, and in A6 enter =A5*60 for seconds. Press the <item type="keycode">Enter</item> key after each formula.</paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_id3149207" xml-lang="en-US" l10n="U" oldref="17">The time since your date of birth will be calculated and displayed in the various units. The values are calculated as of the exact moment when you entered the last formula and pressed the Enter key. This value is not automatically updated, although "Now" continuously changes. In the <emph>Tools</emph> menu, the menu item <emph>Cell Contents - AutoCalculate</emph> is normally active; however, automatic calculation does not apply to the function NOW. This ensures that your computer is not solely occupied with updating the sheet.</paragraph> -<paragraph role="paragraph" id="par_id3166428" xml-lang="en-US" l10n="K" oldref="18">-</paragraph> -<embed href="text/shared/00/00000004.xhp#related"/> +<paragraph role="paragraph" id="par_id3149207" xml-lang="en-US" l10n="U" oldref="17">The time since your date of birth will be calculated and displayed in the various units. The values are calculated as of the exact moment when you entered the last formula and pressed the <item type="keycode">Enter</item> key. This value is not automatically updated, although "Now" continuously changes. In the <emph>Tools</emph> menu, the menu item <emph>Cell Contents - AutoCalculate</emph> is normally active; however, automatic calculation does not apply to the function NOW. This ensures that your computer is not solely occupied with updating the sheet.</paragraph> +<section id="relatedtopics"> <embed href="text/scalc/guide/calc_timevalues.xhp#calc_timevalues"/> +</section> </body> </helpdocument> |