6 timetotext, Timetotext – Metrohm viva 1.1 User Manual

Page 81

Advertising
background image

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

2 General program functions

viva 1.1

■■■■■■■■

69

NOTE

Both for the automatic and explicit conversion of a Time to the Num-
ber
type, 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, although a relational operation, for
example, is carried out using the exact value.

Parameters
Time

This parameter can be indicated either in the form of a time function or as
a variable of the Time type.

Examples
TimeToNumber(Time()) = current date and current time represented as
Number (in days since December 1899)

TimeToNumber(Time(1999;12;31;23;59;59)) = 36,525.95832

TimeToNumber(Time('TestYear';'TestMonth';'TestDay')) = Value of
the common variables as number of days as a Number

2.3.4.7.6

TimeToText

Dialog window: Formula editor

Operators/Functions

Syntax
y = TimeToText(Time)

Returns the time entered as Text.

y = TimeToText(Time;Format)

Returns 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 Date/Time type.

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 quotation marks:

Advertising