Metrohm tiamo 1.3 Manual User Manual
Page 75
Formula editor
49
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
.
Parameter
Text
The parameter must only contain numerical characters or Variables of the
type
Text
as otherwise type conversion is not possible (result = "
invalid
").
You can use the following characters as Separators between year, month,
etc.: slash (
/
), full stop (
.
), minus (-), semicolon (
;
), colon (
:
), empty space
and comma. You can determine the Sequence of the individual entries
yourself, but these must be entered in the parameter
Format
.
Format
Defines in which format or sequence the text must be entered. This pa-
rameter must be enclosed with Inverted commas and can be composed
of the following code characters: