|
  |
|
|
| Contents | Index Calculations on times and dates You may also perform calculations on time and date formatted columns. In some cases, you may want to include both, such as in calculating the time required for a procedure that started at 13:33 on 1/12/94 and ended at 12:23 on 1/13/94. Time based calculations When a column that is time formatted is included in a formula, it is converted to seconds. If the column containing the calculation is also time formatted, the result of the calculation will be displayed in the cell in time format. If numeric or character format is used, it will be displayed in seconds. Thus, when using time formatted cells in formulas, you may wish to convert to minutes (by dividing by 60) or hours (by dividing by 3600). Date based calculations When a column that is date formatted is included in a formula, it is converted to days since January 1, 1970 (apparently when programmers consider the first date in time). Since dates are generally used in calculations only in reference to (subtraction from) other dates, this won’t matter much. The result of a subtraction of one date from another will be in terms of days. |
|
|
