Metrohm tiamo 2.3 Manual - Manual (Page 96)

2.4 Formula editor ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
80 ￭￭￭￭￭￭￭￭ tiamo 2.3
Characters Significance
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).
Examples
TextToTime("2004-12-3 5:22:01 PM";"yMdhmsa") = 2004-12-03
17:22:01 UTC+1 (dependent on the system time)
TextToTime("12-15-01 2001:3:5";"HmsyMd") = 2001-03-05
12:15:01 UTC+1 (dependent on the system time)
TextToTime('CV.TestDate';'CV.TestFormat') = Values of the com-
mon variables in the time format indicated
TextToTime('MV.ID1';'CV.TestFormat') = entered text of ID1 in the
time format indicated
2.4.4.7.5 TimeToNumber
Dialogfenster: Formula editor ▶ Operators/Functions
Syntax
y = TimeToNumber(Time)
Returns the entered time as a Number.