2 arithmetical operators, 1 addition, Addition – Metrohm tiamo 2.4 (process analysis) User Manual

Page 74

Advertising
background image

2.4 Formula editor

■■■■■■■■■■■■■■■■■■■■■■

58

■■■■■■■■

tiamo 2.4 (for Process Analysis)

2.4.4.2

Arithmetical operators

2.4.4.2.1

Addition

Dialog window: Formula editor

Operators/Functions

Syntax
Operand1 + Operand2

The operands can be entered either directly or as a variable and can be of
the type Text, Number or Date/Time.

Examples

Operand1

Operand2

Result

Example

Remark

both operands of the same type:

Number

Number

Number

1.2 + 3 = 4.2

-

Text

Text

Text

"Metrohm" + "AG" =
"Metrohm AG"

If the maximum permissible length
(65 536 characters) of the charac-
ter string is exceeded by addition
of the operands, the surplus char-
acters will be removed from the
second operand.

Time

Time

Number

Time(1998;04;06) +
Time(1964;02;03) = 59300.875
(for
UTC+1)

Result: Number of days calculated
from December 1899, dependent
on the system time

Operand of different type: The operand which does not correspond to the result type is converted to the relevant
result type before the operation.

Number

Text

Text

1.2 + "Metrohm" = "1.2Metrohm"

-

Text

Number

Text

"Metrohm" + 1.2 = "Metrohm1.2"

-

Number

Time

Number

2.0 + Time(1999;11;7) = 36472.96
(for UTC+1)

Result: Number of days calculated
from December 1899, dependent
on the system time

Time

Number

Number

Time(1999;10;7) + 2.0 = 36441.92
(for UTC+2)

Result: Number of days calculated
from December 1899, dependent
on the system time

Text

Time

Text

"Metrohm" + Time(1999;10;7) =
"Metrohm1999-10-07 00:00:00
UTC+2"

Before the operation, the operand
of the type Date/Time is con-
verted to Text.

Time

Text

Text

Time(1999;01;7) + "Metrohm" =
"1999-01-07 00:00:00 UTC
+1Metrohm"

The same rules apply here as for
the previous operation.

Advertising