Metrohm viva 1.0 Manual - Manual (Page 68)

2.3 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
56 ￭￭￭￭￭￭￭￭
viva 1.0
2.3.4.7 Type conversion functions
2.3.4.7.1 NumberToText
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = NumberToText(number)
Returns the entered number as Text.
Parameters
Number
The parameter can be indicated either directly as a number or as a variable
of the Number type.
Examples
NumberToText(–55.3) = –55.3
NumberToText('CV.AverageTemp') = Value of the common variable
(AverageTemp) as Text
2.3.4.7.2 NumberToTime
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = NumberToTime(number)
Returns the entered number as Date/Time, where the number is interpre-
ted as the number of days since December 30, 1899 at 01 hours.
Parameters
Number
The parameter can be indicated either directly as a number or as a variable
of the Number type.
Examples
NumberToTime(35545.526) = 1997-04-25 14:37:26 UTC+2
(dependent on the system time)
NumberToTime(35780.55) = 1997-12-16 14:12:00 UTC+1 (depend-
ent on the system time)
NumberToTime('CV.TestDate') = Value of the common variable (Test-
Date) as Date/Time