Metrohm tiamo 1.0 Manual - Manual (Page 51)

Formula editor 27
Operators - Arithmetic
Addition
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 = 4.2 -
Text Text Text "Metrohm" + "AG" = "Metrohm
AG" If the maximum permitted
length (65'536 characters) of
the character string is exceeded
by the addition of the operands
then the excess characters will
be cut off by the 2
nd
operand.
Time Time Time Time(1998;04;06) +
Time(1964;02;03) = 59300.875
(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" = "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 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 opera-
tion.