Metrohm tiamo 1.1 Manual - Manual (Page 61)

Formula editor 33
Operand1 Operand2 Result Example Remarks
Number Time Number 2.0 + Time(1999;11;7) =
36472.96
(for UTC+1)
Result: number of days calcu-
lated since 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 calcu-
lated since 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 an oper-
and of type
Date/Time is con-
verted to Text .
Time Text Text Time(1999;01;7) + "Metrohm" =
"1999-01-07 00:00:00
UTC+1Metrohm" In this case the same rules
apply as for the previous op-
eration.
Subtraction
Syntax
Operand1 - Operand2
The operands can either be entered directly or as a Variable and can be
of the type
Text , Number or Date/Time .
Examples
Operand1 Operand2 Result Example Remarks
Both operands of the same type:
Number Number Number
1.2 - 3 = -1.8 -
Text Text Text "Metrohm" - "AG" = invalid This operation is not permitted.
Time Time Number Time(1998;01;06) -
Time(1964;12;03) = 12'087.00
(for UTC+1)
Time() : see function
Time(Date)
Result: number of days calcu-
lated since December 1899,
dependent on the system time
Operands of different types: the operand that does not correspond to the type of result is converted
to the particular result type before the operation.
Number Text
Text 1.2 - "Metrohm" = invalid This operation is not permitted.
Text Number Text "Metrohm" - 1.2 = invalid This operation is not permitted.
Number Time Number 2.0 - Time(1999;10;7) = -
36'437.917
(for UTC+2)
Result: number of days calcu-
lated since 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 calcu-
lated since December 1899,
dependent on the system time
Text Time Text "Metrohm" - Time(1999;10;7) =
invalid This operation is not permitted.
Time Text Text Time(1999;10;7) - "Metrohm" =
invalid This operation is not permitted.