Metrohm tiamo 1.1 Manual - Manual (Page 81)

Formula editor 53
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
TimeToText
Syntax
y = TimeToText(Time)
Returns the entered time as Text .
y = TimeToText(Time;Format)
Returns the entered time as Text in the required format.
Parameter
Time
This parameter can be entered in either the form of a Time function or as a
Variable of the type
Date/Time .
Format
Defines in which format or sequence the text must be entered. This pa-
rameter must be enclosed with Inverted commas and can be composed
of the following code characters:
Character Meaning Example
y 2-place date in years 03
yyyy 4-place date in years 1999
M 1- or 2-place date in months 4, 12
MM 2-place date in months 04, 12
MMM Abbreviated name of month Jul, Aug
MMMM Month name July, August
d 1- or 2-place date in days 2, 25
dd 2-place date in days 02, 25
h 1- or 2-place time in hours (1...12 AM/PM) 5, 11
hh 2-place time in hours (1...12 AM/PM) 05, 11
H 1- or 2-place time in hours (0...23) 8, 17
HH 2-place time in hours (0...23) 08, 17
m 1- or 2-place time in minutes 2, 25
mm 2-place time in minutes 02, 25
s 1- or 2-place time in seconds 3, 55