Metrohm tiamo 1.2 Manual - Handbuch (Seite 77)

Formula editor 51
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
ss 2-place time in seconds 03, 55
E Abbreviated day of week Mo, Tu, We
EEEE Day of week Monday, Tuesday
D 1- , 2- or 3-place number of day in year 2, 35, 142
DD 2- or 3-place number of day in year 02, 35, 142
DDD 3-place number of day in year 002, 035, 142
F 1-place number of day in month, e.g. the 2nd Monday in May 2
w 1- or 2-place number of week in year 5, 25
ww 2-place number of week in year 05, 25
W 1-place number of week in month 3