Metrohm tiamo 2.2 (ProcessLab) - Manual (Page 68)

2.4 Formula editor ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
52 ￭￭￭￭￭￭￭￭ tiamo 2.2 (ProcessLab)
Operand1 Operand2 Result Example Remark
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
Time Number Number Time(1999;10;7) - 2.5 =
36'437.917 (for UTC+2) Result: Number of days calculated
from December 1899, dependent
on the system time
Text Time Text "Metrohm" - Time(1999;10;7) =
invalid This operation is not allowed.
Time Text Text Time(1999;10;7) - "Metrohm" =
invalid This operation is not allowed.
2.4.4.2.3 Multiplication
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
Operands of the same type:
Number Number Number 1.2 * 3 = 3.6 -
Text Text Text "Metrohm" * "AG" = invalid This operation is not allowed.
Time Time Number Time(1998;05;06) * Time(1902;02;03)
= 27'478'004.545 (for UTC+1 or +2 for
summer time) Result: Number of days calcula-
ted 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 2 * "Metrohm" = "MetrohmMetrohm" -
Text Number Text "Metrohm" * 2 = "MetrohmMetrohm" -