7 type conversion functions, 1 numbertotext, 2 numbertotime – Metrohm tiamo 2.3 (process analysis) User Manual

Page 94: Numbertotext, Numbertotime

Advertising
background image

2.4 Formula editor

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

78

■■■■■■■■

tiamo 2.3 (for Process Analysis)

2.4.4.7

Type Conversion functions

2.4.4.7.1

NumberToText

Dialogfenster: Formula editor

Operators/Functions

Syntax
y = NumberToText(number)

Returns the entered number as Text.

Parameters
Number

The parameter can be indicated either directly as a number or as a variable
of the type Number.

Examples
NumberToText(-55.3) = -55.3

NumberToText('CV.AverageTemp') = Vale of the common variable
(AverageTemp) as Text

2.4.4.7.2

NumberToTime

Dialogfenster: Formula editor

Operators/Functions

Syntax
y = NumberToTime(number)

Returns the entered number as Date/Time, whereby the number is inter-
preted as the number of days since December 30, 1899 at 01 hours.

Parameters
Number

The parameter can be indicated either directly as a number or as a variable
of the type Number.

Examples
NumberToTime(35545.526) = 1997-05-25 14:37:26 UTC+2
(dependent on the system time)

NumberToTime(35780.55) = 1997-12-16 14:12:00 UTC+1 (depend-
ent on the system time)

NumberToTime('CV.TestDate') = Value of the common variable (Test-
Date) as Date/Time

Advertising