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

2.4 Formula editor ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
48 ￭￭￭￭￭￭￭￭ tiamo 2.1 (ProcessLab)
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" -
Number Time Number 2.0 * Time(1999;10;7) = 72'879.833
(for UTC+2) Result: Number of days calcula-
ted from December 1899,
dependent on the system time
Time Number Number Time(1999;10;7) * 2.0 = 72'879.833
(for UTC+2) Result: Number of days calcula-
ted from December 1899,
dependent on the system time
Text Time Text "Metrohm" * Time(1999;10;7) = inva-
lid This operation is not allowed.
Time Text Text Time(1999;10;7) * "Metrohm" = inva-
lid This operation is not allowed.
2.4.4.2.4 Division
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 = 0.4 Operand2 must not be zero!
Text Text Text "Metrohm" / "AG" = invalid This operation is not allowed.
Time Time Number Time(1998;04;06) /
Time(1964;02;03) = 1.533 (for UTC
+1 or +2 for summer time) Result: Number of days calculated
from December 1899, dependent
on the system time