2 numbertotime, 3 texttonumber, Numbertotime – Metrohm tiamo 2.4 (process analysis) User Manual
Page 96: Texttonumber
2.4 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
80
■■■■■■■■
tiamo 2.4 (for Process Analysis)
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 (depen-
dent on the system time)
NumberToTime('CV.TestDate') = Value of the common variable (Test-
Date) as Date/Time
2.4.4.7.3
TextToNumber
Dialogfenster: Formula editor
▶ Operators/Functions
Syntax
y = TextToNumber(Text)
Returns 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