2 subtraction, Subtraction – Metrohm viva 1.0 Manual User Manual
Page 47
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
viva 1.0
■■■■■■■■
35
Operand1
Operand2
Result
Example
Remark
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
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" = invalid
This operation is not allowed.
Text
Number
Text
"Metrohm" – 1.2 = invalid
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.