Metrohm tiamo 2.3 Patch 1 - Manual (Page 100)

2.4 Formula editor ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
84 ￭￭￭￭￭￭￭￭ tiamo 2.3 Patch 1
Note
Both for the automatic and explicit conversion of a Time to the type
Number, the number of days are counted since December 30, 1899
at 01 hours.
Attention: December 30, 1899 01 hours = 0.00000 days, this number
is rounded off to 5 decimal places, but a relational operation for exam-
ple is carried out with the exact value.
Parameters
Time
This parameter can be indicated either in the form of a time function or as
a variable of the type Time.
Examples
TimeToNumber(Time()) = current date and current time represented as
Number (in days since December 1899)
TimeToNumber(Time(1999;12;31;23;59;59)) = 36525.95832
TimeToNumber(Time('TestYear';'TestMonth';'TestDay')) = Value of
the common variables as number of days as a Number
2.4.4.7.6 TimeToText
Dialogfenster: Formula editor ▶ Operators/Functions
Syntax
y = TimeToText(Time)
Returns 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: