4 texttotime, Texttotime – Metrohm tiamo 2.4 (process analysis) User Manual
Page 97

■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
tiamo 2.4 (for Process Analysis)
■■■■■■■■
81
TextToNumber('CV.AverageTemp') = Value of the variables (Average-
Temp) as Number
TextToNumber('MV.ID1') = entered text of ID 1 as Number
2.4.4.7.4
TextToTime
Dialogfenster: Formula editor
▶ Operators/Functions
Syntax
y = TextToTime(Text;Format)
Returns 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 separator between 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).