Metrohm tiamo 1.2 Manual - Handbuch (Seite 57)

Formula editor 31
Operand1 Operand2 Result Example Remarks
Time Number Number Time(1999;10;7) + 2.0 =
36441.92
(for UTC+2)
Result: number of days calculated
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 operand of
type
Date/Time is converted 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 operation.
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 calculated
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 calculated
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 calculated
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.