Metrohm tiamo 1.2 Manual - Handbuch (Seite 76)

50 General program functions
Character Meaning
y Year
M Month
d Day
H Hour 0...23
h Stunde AM/PM
m Minute
s Second
a AM/PM marking
Note
If you enter the time in the format AM/PM then in addition to the formatting cha-
racter h you must us 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
(depends on the system time)
TextToTime("12-15-01 2001:3:5";"HmsyMd") = 2001-03-05 12:15:01 UTC+1
(depends on the system time)
TextToTime('CV.TestDate';'CV.TestFormat') = values of the Common vari-
ables in the entered time format
TextToTime('MV.ID1';'CV.TestFormat') = entered text of ID1 in the given time
format
TimeToNumber
Syntax
y = TimeToNumber(Time)
Returns the entered time as Number .
Note
In both the automatic and the explicit conversion of a Time into the type Num-
ber the number of days since 30 December 1899 at 01 a.m. will be counted.
Note: 30 December 1899 01 a.m. = 0.00000 days, this number is rounded to 5
decimal places; however, e.g. a comparative operation will be carried out with
the exact value.
Parameter
Time
This parameter can be entered in either the form of a Time function or as a
Variable of the type
Time .
Examples
TimeToNumber(Time()) = current date and current time shown as a Number
(in days since December 1899)
TimeToNumber(Time(1999;12;31;23;59;59)) = 36525.95832
TimeToNumber(Time('TestYear';'TestMonth';'TestDay')) = value of the Com-
mon variables as number of days as Number