5 timetonumber, Timetonumber – Metrohm viva 1.1 (ProLab) User Manual
Page 80
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
68
■■■■■■■■
viva 1.1 (for process analysis)
Characters
Meaning
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 AM/PM format, 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('SD.ID1';'CV.TestFormat') = entered text of ID1 in the
time format indicated
2.3.4.7.5
TimeToNumber
Dialog window: Formula editor
▶ Operators/Functions
Syntax
y = TimeToNumber(Time)
Returns the entered time as a Number.