< Day Day Up > |
Calc supports almost every national and international date and time format. Calc converts date and time values that you type to a special internal number that represents the number of days since midnight January 1, 1900. Although this strange internal date representation of days since 1-1-1900 might not make sense at first, you'll use these values to compute time between two or more dates. You can easily determine how many days an account is past due, for example, by subtracting the current date from the cell in the worksheet that contains the due date. Before You Begin 41 Enter Simple Data into a Spreadsheet 52 Enter Calc Functions See Also 59 Format Cells If you enter a date in a longer format, such as July 4, 1776 , Calc usually converts the date to another format (such as 7/4/76 18:15 ). You can enter a date, a time value, or both. You can format the date and time values you enter (see 59 Format Cells ) to take on any format you wish. TIP
|
< Day Day Up > |