Metrohm tiBase 1.1 - Manual (Page 68)

2.4 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
60 ￭￭￭￭￭￭￭￭
tiBase 1.1
2.4.4.7.6 TimeToText
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = TimeToText(Time)
Gives the time entered as Text.
y = TimeToText(Time;Format)
Gives the time entered as Text in the required format.
Parameters
Time
This parameter can be indicated either in the form of a time function or as
a variable of the type Date/Time.
Format
Indicates in which format or order the time is to be output as text. This
parameter can comprise the following code characters and must be
marked by inverted commas:
Characters Significance Example
y two-digit year number 03
yyyy four-digit year number 1999
M one or two-digit month number 4, 12
MM two-digit month number 04, 12
MMM Month name short form Jul, Aug
MMMM Month name July, August
d one or two-digit day number 2, 25
dd two-digit day number 02, 25
h one-digit or two-digit hour number
(1…12 AM/PM) 5, 11
hh two-digit hour number (1…12 AM/
PM) 05, 11
H one-digit or two-digit hour number
(0…23) 8, 17
HH two-digit hour number (0…23) 08, 17
m one or two-digit minute number 2, 25
mm two-digit minute number 02, 25
s one or two-digit second number 3, 55
ss two-digit second number 03, 55