Metrohm tiamo 1.3 Manual User Manual
Page 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 char-
acter
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