Metrohm tiBase 1.1 - Manual (Page 66)

2.4 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
58 ￭￭￭￭￭￭￭￭
tiBase 1.1
TextToNumber('CV.DurchschnTemp') = Value of the variables (Avera-
geTemp) as Number
TextToNumber('MV.ID1') = entered text of ID 1 as Number
2.4.4.7.4 TextToTime
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = TextToTime(Text;Format)
Gives the entered text as a Date/Time.
Parameters
Text
The parameter may only contain numerical characters or variables of
the type Text, as otherwise a type conversion is not possible (Result =
invalid). As a delimiter betwen Year, Month etc. you can use the follow-
ing characters: slash (/), full stop (.), minus (-), semi-colon (;), colon (:),
space and comma. You can determine the order of the individual data
yourself, but must indicate this in the Format parameter.
Format
Indicates in which format or order the text has been entered. This para-
meter must be marked by inverted commas and can comprise the fol-
lowing code characters:
Characters Significance
y Year
M Month
d Day
H Hour 0…23
h Hour AM/PM
m Minute
s Second
a AM/PM marking
Note
If you indicate the time in the format AM/PM, it is necessary in addi-
tion to the formatting character h to use the AM/PM marking a (see
first example below).