diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/guide/calc_date.xhp')
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/calc_date.xhp | 105 |
1 files changed, 105 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/guide/calc_date.xhp b/helpcontent2/source/text/scalc/guide/calc_date.xhp new file mode 100755 index 0000000000..143f1517f2 --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/calc_date.xhp @@ -0,0 +1,105 @@ +<?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="textscalcguidecalc_datexml" indexer="include" status="DEPRECATED"> +<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> +</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> +<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> +<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> +</listitem> +<listitem> +<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> +</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> +</listitem> +<listitem> +<paragraph role="listitem" id="par_id3147343" xml-lang="en-US" l10n="U" oldref="54">The <emph>Format Cells</emph> dialog appears. On the <emph>Numbers</emph> tab, the <emph>Number</emph> category will appear already highlighted. The format is set to "General", which causes the result of a calculation containing date entries to be displayed as a date. To display the result as a number, set the number format to "-1,234" and close the dialog with the OK button.</paragraph> +</listitem> +<listitem> +<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> +</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"/> +<embed href="text/scalc/guide/calc_timevalues.xhp#calc_timevalues"/> +</body> +</helpdocument> |