3 multiplication, Multiplication – Metrohm tiamo 2.3 (process analysis) User Manual

Page 74

Advertising
background image

2.4 Formula editor

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

58

■■■■■■■■

tiamo 2.3 (for Process Analysis)

Operand1

Operand2

Result

Example

Remark

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.

2.4.4.2.3

Multiplication

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 type Text, Number or Date/Time.

Examples

Operand1

Operand2

Result

Example

Remark

Operands of the same type:

Number

Number

Number

1.2 * 3 = 3.6

-

Text

Text

Text

"Metrohm" * "AG" = invalid

This operation is not allowed.

Time

Time

Number

Time(1998;05;06) *
Time(1902;02;03) = 27'478'004.545
(for UTC+1 or +2 for summer time)

Result: Number of days calcula-
ted from December 1899,
dependent on the system time

Operand of different type: The operand which does not correspond to the result type is converted to the relevant
result type before the operation.

Number

Text

Text

2 * "Metrohm" = "MetrohmMe-
trohm"

-

Text

Number

Text

"Metrohm" * 2 = "MetrohmMe-
trohm"

-

Number

Time

Number

2.0 * Time(1999;10;7) = 72'879.833
(for UTC+2)

Result: Number of days calcula-
ted from December 1899,
dependent on the system time

Time

Number

Number

Time(1999;10;7) * 2.0 = 72'879.833
(for UTC+2)

Result: Number of days calcula-
ted 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.

Advertising