beautypg.com

2 subtraction, Subtraction – Metrohm viva 1.0 Manual User Manual

Page 47

background image

■■■■■■■■■■■■■■■■■■■■■■

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.