Metrohm tiamo 2.3 Patch 1 - Manual (Page 76)

2.4 Formula editor ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
60 ￭￭￭￭￭￭￭￭ tiamo 2.3 Patch 1
Operand1 Operand2 Result Example Remark
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 conver-
ted 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.4.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 type Text, Number or Date/Time.
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
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" = invalid This operation is not allowed.
Text Number Text "Metrohm" - 1.2 = not valid This operation is not allowed.
Number Time Number 2.0 - Time(1999;10;7) =
-36'437.917 (for UTC+2) Result: Number of days calculated
from December 1899, dependent
on the system time