openoffice calculate total hours minutes

Traditionally, subtraction does not have a function, apparently on the grounds that it is too simple for one to be any of benefit - although the same could be said, it seems to me, about the other basic functions. You can use SUM for addition, PRODUCT for multiplication, and QUOTIENT for division. The most basic functions in Calc are simple arithmetic: Addition, subtraction, multiplication, and division (or, as Alice in Wonderland calls them, Ambition, Distraction, Uglification, and Derision).Įxcept for subtraction, each of these operations has its own function. With this quick recap in mind, you are now ready to try some useful simple functions: Basic arithmetic The Wizard also includes input fields and displays errors, both of which can become useful as you become more experienced.

The Function Wizard is the easiest method for beginners, since you can choose a range of cells from it with the mouse, the Wizard's window conveniently minimizing so that you can see the spreadsheet more easily. You can enter formulas using either the formula bar or by selecting Insert -> Function, which opens the Function Wizard. You can enter a range of cells by specifying the first and the last cell in the range, separated by a colon for example, A1:A4 includes cells A1 and A4, as well as A2 and A3. In some cases, an argument takes a specific number, which has a particular meaning you probably have to look up.Ĭell addresses consist of a letter for the column and a number for the row, so that A1 is the top left cell. Both functions and formulas begin with an equal sign, and take either numbers or cell addresses as arguments. Technically, it becomes a formula when arguments are entered into it, although the two terms are often used interchangeablely. A function is the building block for a spreadsheet equation. However, Calc includes dozens of functions that anyone can use, the most basic of which create formulas for basic arithmetic or for evaluating numbers in a range of cells.īut before plunging into the examples below, take the time to review the basic structure of functions. Nor are the often circular definitions of the Function Wizard much help: You are no better off for reading that the SKEW function 'returns the skewness of a distribution,' for example. Newcomers quickly learn that functions are a main feature of spreadsheets, but there are almost four hundred, and many require input that assume specialized knowledge. For novices, functions are one of the most intimidating features of 's Calc.

Openoffice calculate total hours minutes