Metrohm viva 1.0 (process analysis) - Manual (Page 48)

2.3 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
36 ￭￭￭￭￭￭￭￭
viva 1.0 (for Process analysis)
Operand1 Operand2 Result Example Remark
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) = 59,300.875
(for UTC+1) Result: Number of days calculated
from December 1899, dependent
on the system time
Operands of a different type: The operand which does not correspond to the result type is converted to the rele-
vant 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) = 36,472.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 = 36,441.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 Date/Time type 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.
2.3.4.2.2 Subtraction
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 Text, Number or Date/Time type.
Examples
Operand1 Operand2 Result Example Remark
both operands of the same type:
Number Number Number 1.2 – 3 = –1.8 –
Text Text Text "Metrohm" – "AG" = invalid This operation is not allowed.
Time Time Number Time(1998;01;06) –
Time(1964;12;03) = 12,087.00 (for
UTC+1) Result: Number of days calculated
from December 1899, dependent
on the system time