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

￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭ 2 General program functions
tiamo 2.1 (ProcessLab) ￭￭￭￭￭￭￭￭ 69
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 = inva-
lid). As a delimiter betwen Year, Month etc. you can use the following
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 parameter
must be marked by inverted commas and can comprise the following 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 addition
to the formatting character h to use the AM/PM marking a (see first
example below).