Metrohm tiamo 2.1 (ProcessLab) - Manual (Page 84)

2.4 Formula editor ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
68 ￭￭￭￭￭￭￭￭ tiamo 2.1 (ProcessLab)
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
2.4.4.7.3 TextToNumber
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = TextToNumber(Text)
Gives the entered text as a number.
Parameters
Text
The parameter may only contain numerical characters or variables of the
type Text, as otherwise a type conversion is not possible. The result of this
conversion or the calculation would then be invalid. In addition, text must
be marked by inverted commas.
Examples
TextToNumber("-55.3") = -55.3