6 timetotext, Timetotext – Metrohm tiamo 2.2 (ProcessLab) User Manual

Page 91

Advertising
background image

■■■■■■■■■■■■■■■■■■■■■■

2 General program functions

tiamo 2.2 (ProcessLab)

■■■■■■■■

75

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 example
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';'TestTag')) = Value of
the common variables as number of days as a Number

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:

Advertising