Metrohm tiamo 2.2 (ProcessLab) - Manual (Page 90)

2.4 Formula editor ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
74 ￭￭￭￭￭￭￭￭ tiamo 2.2 (ProcessLab)
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 addition
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 common
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
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = TimeToNumber(Time)
Gives the entered number as a Number.