Metrohm tiamo 2.2 (ProcessLab) - Manual (Page 88)

2.4 Formula editor ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
72 ￭￭￭￭￭￭￭￭ tiamo 2.2 (ProcessLab)
2.4.4.7 Type Conversion functions
2.4.4.7.1 NumberToText
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = NumberToText(numberl)
Gives 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) als Text
2.4.4.7.2 NumberToTime
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = NumberToTime(number)
Gives the entered number as Date/Time, whereby the number is interpre-
ted 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 (Number-
ToTime(35545.526) = 1997-05-25 14:37:26 UTC+2 (dependent on the
system time)
NumberToTime('CV.TestDate') = Value of the common variable (Test-
Date) as Date/Time