Numbertotime, Texttonumber, Texttotime – Metrohm tiamo 1.1 Manual User Manual
Page 79
Formula editor
51
Parameter
Number
The parameter can either be entered directly as a number or as a Variable
of the type
Number
.
Examples
NumberToText(-55.3) = -55.3
NumberToText('CV.MeanTemp')
= value of the Common variable as
Text
NumberToTime
Syntax
y = NumberToTime(Number)
Returns the entered number as
Date/Time
, with the number being inter-
preted as the number of days since 30 December 1899 at 01 a.m.
Parameter
Number
The parameter can either be entered directly as a number or as a Variable
of the type
Number
.
Examples
NumberToTime(35545.526) = 1997-05-25 14:37:26 UTC+2
(depends on the
system time)
NumberToTime(35780.55) = 1997-12-16 14:12:00 UTC+1
(depends on the
system time)
NumberToTime('CV.TestDate')
= value of the Common variable as
Date/Time
TextToNumber
Syntax
y = TextToNumber(Text)
Returns the entered text as
Number
.
Parameter
Text
The parameter must only contain numerical characters or Variables of the
type
Text
as otherwise type conversion is not possible. The result of this
conversion or calculation would be "
invalid
". The text must also be enclosed
by Inverted commas.
Examples
TextToNumber("-55.3") = -55.3
TextToNumber('CV.MeanTemp')
= value of the Common variable as a
Num-
ber
TextToNumber('MV.ID1')
= entered text of
ID 1
as a
Number
TextToTime
Syntax
y = TextToTime(Text;Format)
Returns the entered text as
Date/Time
.