Metrohm tiamo 2.1 (ProcessLab) - Manual (Page 62)

2.4 Formula editor ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
46 ￭￭￭￭￭￭￭￭ tiamo 2.1 (ProcessLab)
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 character
string is exceeded by addition of the
operands, the surplus characters
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 converted
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.